June 9, 2006 at 4:44 am
Hi all
Have a couple of scheduled DTS local packages that export tables to xls documents. Until today, everything was working fine, but now they don't work. BTW, running SQL Server 2k.
The error message is:
Executed as user: xxx\SYSTEM. DTSRun: Cannot create COM Server to load and execute DTS Package. Error -2147221164 (80040154): Class not registered. Process Exit Code -2147221164. The step failed.
Tried to run in command line but same error.
Checked post http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=128267 but does not help.
Can anyone help me to fix this?
Also, how can I check wich SP ins installed on the server?
Thanx.
CSerrano
LX-Portugal
June 12, 2006 at 8:00 am
This was removed by the editor as SPAM
June 12, 2006 at 1:47 pm
I'll take a stab at it. Sounds like the SQL Client Tools on the workstation you're running EM on isn't installed completely. I ran into this same situation when attempting to run DTS packages from a .Net app. dtsrun.dll wasn't installed for some reason. I uninstalled and reinstalled the client tools and, voila, it worked.
June 30, 2006 at 9:28 am
Check this out.
http://support.microsoft.com/?scid=kb%3Ben-us%3B288910&x=15&y=16
Maninder
www.dbanation.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply