When I attempt to run a job that executes a DTS script I'm
recieving this error. I can run the job successfully if I
open it. Could this be because I created the job using
SQL 2k and I'm running it on a SQL 7 server? I can
schedule the job and run it fine from a 2k machine. MS
online doesn't seem to have anything on this error.

DTSRun: Loading...

Error: -2147221164 (80040154); Provider Error: 0 (0)
Error string: Class not registered
Error source: Microsoft Data Transformation Services
(DTS) Package
Help file: sqldts.hlp
Help context: 713

Any help is appreciated!

Thanks,

Erik Klein
erik (AT) klein (DOT) ca

Make sure the package does not have anything in it that is related only to
SQL Server 2000 i.e. FTP task, Dynamic Properties task.
If you developed it on 2000 then save the package with a password and
specify that when you want to run it



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Erik Klein" <erik.klein (AT) dfait-maeci (DOT) gc.ca> wrote

This could be that you created it on a machine that has certain software
(ex: .NET) on it that the server does not have.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Are the servers the same OS service pack? Has to be somethign different
on the target server.

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!