Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    2

    Unanswered: DTS execution from T-SQL

    I really need help!!!

    I built a DTS package that makes data pump from Paradox 7.0 to SQL Server. If I execute this package from Package Designer everything goes fine no matter if Paradox files are located in local or mapped folders.

    However, If I execute the package from T-SQL, it crashes when if Paradox files are located in a mapped drive saying "not valid path" (With local folder it works)

    Im using xp_cmdshell 'DTS_Run /S "server name" /N "package name" /E'

    Can anyone tell me whats wrong with this

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    First of all check whether the account used have necessary privileges to carry tasks on paradox and on the machine.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •