I have several DTS packages (local) that run fine when executed manually from
EM, but when run as scheduled jobs they fail with the following error message:

Executed as user: AD-ENT\SHEQ_SS. ...nStart: DTSStep_DTSExecuteSQLTask_1
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: Create Table
TEMP_DLY_APPLICATION Step DTSRun OnFinish: Create Table
TEMP_DLY_APPLICATION Step DTSRun OnStart: Copy Data from Results to
TEMP_DLY_APPLICATION Step DTSRun OnError: Copy Data from Results to
TEMP_DLY_APPLICATION Step, Error = -2147221005 (800401F3) Error string:
Invalid class string Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context: 700
Error Detail Records: Error: -2147221005 (800401F3); Provider
Error: 0 (0) Error string: Invalid class string Error source:
Microsoft Data Transformation Services (DTS) Package Help file:
sqldts80.hlp Help context: 700 Error: -2147221005 (800401F3);
Provider Error: 0 (0) Error string: Invalid class string Error
source: Microsoft ... Process Exit Code 1. The step failed.

I notice that this is a common problem. I've checked a couple of the
knowledge base articles, but they don't seem to relate to my problem.

Have a look at this


http://support.microsoft.com/?kbid=288910

and also at this


http://www.sqldts.com/default.aspx?223

Let us know if they help.


"RanceR" wrote:

For the benefit of others looking at this issue:
I have determined that the reason I am getting this error is that the IBM
DB2 provider does not exist on the server. Because I have this provider on
my desktop client, I am able to run it manually from the EM. If I remote to
the server and try running it from EM I get an immediate error. And, of
course it won't run as a scheduled job as well.

"Allan Mitchell" wrote: