Some DTS jobs fail but not all

[sarahnice]

Hi,

I am using SQL Server 2000. I have crated some DTS packages to transfer the logins of databases between servers. I then created jobs to run these packages using the DTSRun command. All of the jobs, apart from one, are running successfully. The one job that fails gives the following error:

Executed as user: UUSD\#sqladmin. DTSRun: Loading... Error: -2147220460 (80040414); Provider Error: 0 (0) Error string: Cannot find specified package in the storage location specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713. Process Exit Code 1. The step failed.

The user #sqladmin is a domain account with admin privelages on both servers. It is also the account used to start SQL Server and the Agent services.

I've found a lot of information about permissions, etc., but it doesn't explain why only one of the jobs is failing. The jobs that are running successfully are almost identical to this one. The only difference is that they are running different DTS packages. I ran the package manually and it runs fine.

Any ideas???????

 

[Corran007]

Its failing cause it cannot find the package where you say it is. i would make sure that the package exists still. If you are storing it in sqlserver, i would delete the job then recreate it.

 

[sarahnice]

I have deleted the job but i'm still getting the same error. The DTS package is in the same place as all the others but none of them are causing an error. This is the only job that fails, even though the others are almost identical.