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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment