> SQL 2000 on Server 2003
>
> I've created 8 different DTS packages and scheduled them by right
> clicking on them. 6 of them work fine. However, 2 of them get the same
> error when the job is run (they run fine if I right click on the
> package and select 'Execute Package'). Here's the error:
>
> DTSRun: Loading... 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: 713. Process Exit Code
> 1. The step failed.
> I'm thinking the error must be inside the dts since my other jobs run
> fine. I'm wondering if someone knows some typical errors that I can
> look for in my code. Thanks
>

> I've determined my problem is with "SMTP Mail Task" from sqldev.net.
> This is the first time I've used it in a scheduled dts. I'm using it
> to send success/failure emails. The scheduled job works if I remove it
> from my package. Hopefully I can find something else without resorting
> to using MAPI. Any ideas?
>

> Allan,
>
> Yes it's installed on the server. The emails work fine if I execute
> the steps from within the dts package but I get the error when I run
> the scheduled job.
>

> I looked at the properties of both the scheduled job and the package.
> The owner of the scheduled job is the same as the creator of the dts
> package and the computer name for the package is the sql server, not
> any workstation.
>