Tuesday, March 27, 2012

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

ThanksFirst of all check whether the account used have necessary privileges to carry tasks on paradox and on the machine.

No comments:

Post a Comment