DTS runs manually, fails as scheduled job

I've mined countless threads all over the Net where people are having my problem, but none of the solutions I've seen seem to apply.

When I run a DTS package from Enterprise Manager, everything works great. When I schedule the same package as a job, it fails immediately and reports this error:

Executed as user: SERVER-NAME\SYSTEM. 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.

My hunch is the SERVER-NAME\SYSTEM.DTSRun account doesn't have sufficient privileges, but I can't find how/where to fix that.

Help, please.

Thanks,

Doug

Checkout the following links

http://www.sqlmag.com/articles/index.cfm?articleid=46723& - Security in SSIS
http://support.microsoft.com/?kbid=918760 - An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step

Thanks,
Loonysan

|||

"Invalid class string" is not strictly a SQL Server error in DTS. Essentially it means in cannot find the CLSID for a required object when reading the package. This error can also occur when loading a package that contains a CustomTask which has not been registered on the current machine. (http://www.databasejournal.com/features/mssql/article.php/1461391)

PRB: "Invalid class string" error message when opening DTS package
(http://support.microsoft.com/?scid=kb%3Ben-us%3B288910&x=15&y=16)

The top two hits I got from Google, both say pretty much the same thing. Something is missing from your server, which causes the "Invalid class string", or "I cannot find your task".

FYI, general DTS info on jobs-

INF: How to Run a DTS Package as a Scheduled Job
(http://support.microsoft.com/kb/269074/en-us)