Unable to execute the DTS package through SQL job

Last Post 31 Jul 2008 06:04 PM by sharathsuman. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

31 Jul 2008 06:04 PM

I have a step in the SQL job where it executes a DTS package and loads the output to a text file. This particular step is failing when I scheduled the SQL job, and when I execute the same DTS package syntax in the command prompt then it executed fine.

Here is the syntax I am using in the SQL Job.

DTSRUN /S "NAWINWEB022" /N "Export Cantor FilmSourceData" /E

Can you suggest me what is wrong with this syntax.
Every time I need to run the step the manually in cmd prompt

Thanks in Advance,

Acceptable Use Policy