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 Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
sharathsuman
New Member
New Member

--
31 Jul 2008 06:04 PM
Hi,

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,
Sharath
You are not authorized to post a reply.

Acceptable Use Policy