Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbacarbo99
Starting Member
11 Posts |
 Posted - 2004-10-27 : 13:05:54
|
| I am having a problem scheduling a DTS package. I can successfully execute the package from within Enterprise Manager or using the DTSrunui utility.I have tried right clicking on the package in Enterprise Manger to schedule the job. I have used the DTSrunui utility to schedule the job. And I have created a job "from scratch." But I get the same error each time: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 something like this:DTSRun /Sservername/Uusername/Ppassword/NnameofpackageI have used the encrypted DTSRUN statement that is generated when you right click on the package and select Schedule Job option. I have also used the DTSrunui utility to generate the DTSRUN statement. But I still get the same error.The package consists of dropping a table, recreating the table, and loading data into the table from a falt file.Any help that could be offered would be most appreciated.Thank you,Adria |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-27 : 13:07:29
|
| The problem is that the database server is not able to get to the flat file. Is it a local file to the database server? If not, then the account that the SQL services use to log on with need access to the network resource. If you are using Local System account, then that's a problem.Tara |
 |
|
|
dbacarbo99
Starting Member
11 Posts |
Posted - 2004-10-27 : 15:00:48
|
| Thanks for your reply Tara.The flat file IS a local file to the database server. And when I manually execute the DTS package, it runs just fine, including the step where it loads the flat file. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-27 : 15:03:55
|
| Here is how to troubleshoot this. Logon to the database server using the account that the SQL services uses to logon at startup. Open up a cmd window, run your DTSrun.exe command there. This would imitate what the package is doing when scheduled. Do you get the error there too?Does nameofpackage include spaces or anything odd?Tara |
|
|
|
dbacarbo99
Starting Member
11 Posts |
Posted - 2004-10-27 : 16:07:56
|
| THANK YOU! THANK YOU! THANK YOU!That was indeed my problem. The account that SQL services uses to logon did not have sufficient permissions. Job runs GREAT NOW and right on schedule.I appreciate your assistance. I have been banging my head against this for over a day.Best,Adria |
|
|
|
|
|
|
problem scheduling a DTS package