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

    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


  2. #2
    Join Date
    Aug 2002
    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

Posting Permissions

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