Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running a scheduled DTS - error!!

Status
Not open for further replies.

TheJFM

Programmer
Jun 13, 2002
65
GB
I have created a DTS that runs when executed from the DTS interface.

After scheduling the DTS package fails with the following error.


Executed as user: nnn\srvcagnt. The process could not be created for step 1 of job 0x5A777726591F4777777771D130B7 (reason: The system cannot find the file specified). The step failed.


What am I doing wrong? I never had this on previous builds.


Thanks

** Don't reach for the moon when you have the stars. ;-) TheJFM **
 
What version of SQL Server are you using?
Which version of the client tools did you use to design the DTS package?
Can you execute the DTS package from the server (rather than a separate client)?
What does step 1 in the package do?
If it is accessing a file source, does the SQL Server account have permissions on it?

--James
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top