scheduling a package to run -- sql server dts

dbacarbo
10/27/2004 9:31:09 AM

I'm having trouble getting a DTS package to run on a schedule. It's a job
running a single DTS package. The package drops a table, recreates it, and
loads data from a flat file.

I can manually execute the package. But if I try to scheudle it, the job
gets the following error:

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

My DTSRUN statement looks like this:

DTSRun /Sservername/UuserID/Ppassword/Nnameofpackage

I have tried using the Dtsrunui utility to generate the DTSRUN statement as
well as create the job. I have right clicked on the package and used the
wizard to create the job (with the incripted DTSRUN statement). All jobs
created have failed with the exact same message. I am logged on as the SA
user.

Any help would be most appreciated.

Best,

Andrew J. Kelly
10/27/2004 12:41:06 PM

http://www.support.microsoft.com/?id=269074 How to Run a DTS Package as a
Scheduled Job

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

sql server dts : scheduling a package to run