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,