Scheduling a DTS package - job fails

[mutley1]

I regularly have to DTS 11 separate databases to 1 single server, and as such have 11 packages.I have then written one package which executes each package in turn, for arguements sake, I'll call it the master package. Each of the individual packages is connecting with sa and the correct password. When I run the master package manually, all runs fine. However, when I schedule the package, the SQL agent job fails immediately with the following error (owner was sa by default). Couldn't find anything on Technet! Any help appreciated!

DTSRun: Loading... Error: -2147221005 (800401F3); Provider Error: 0 (0) Error string: Invalid class string Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713. Process Exit Code 1. The step failed.

 

[charl2]

I've had the same problem, I reinstalled sqlserver, created a simple DTS package (all our data is situated on an oracle server) and found that my problem is simply the fact that there is no oracle driver installed on the new server. The DTS package will run from the workstation pc as the drivers are installed on it, jobs however are run on the server. So check you have all your drivers installed.

Hope this helps,
Charl

 

[Corran007]

If your using the call package taks(or what ever the little box is), make sure that if you change the package that it calls under it, the guid is different and will need to be changed to the correct version in the one doing the calling. Also try running it from the server directly manually. something is not set up correctly.