Executing DTS package

[ddrandy]

Scheduled a DTS package (SQL 2000) to run nightly. When the DTS package starts it errors out immediately. If we move the same DTS package to a different server and schedule it the Job runs successfully.

I am recieving an error message: Executed as user: SQLSERVER\SYSTEM. The process could not be created for step 1 of job 0xBEE0E7DEFB0731458EE7B875B5063CF2 (reason: The system cannot find the file specified). The step failed.

Any hints on what the issue might be?

Thanks

 

[DrSql]

Can you provide some more details about the DTS. Is it any way creating files or accesing other servers, make sure the user thats running the DTS have access to those folders or files. Explainw ith more detaiuls may be I can direct you for some answers.

Dr.Sql
Good Luck.

 

[ddrandy]

The DTS package deletes all rows from 2 tables. Then, copies all records from 2 other tables that are refreshed into the 2 original tables.

Delete all rows from
Table A
Table B

Insert all records:
Table A1 into Table A
Table B1 into Table B

If we execute the DTS by itself , it runs successfully. It is only when scheduled.

Thanks

 

[DrSql]

Is the user executing the job have full access to the table.

Dr.Sql
Good Luck.

 

[ddrandy]

I believe so, The DTS will execute fine without the scheduler. We connecting as 'sa' to schedule the job.

Thanks,