|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Thursday, March 05, 2009 5:22 PM
Points: 10,
Visits: 107
|
|
This is the following result I found when I try to edit the job step.
Job -> right click -> Properties -> job step -> edit
What is the root cause of this error?
"Creating an instance of the OCM component with CLSID {E80*************}" from the IClassFactory failed due to following error:c001f011(Microsoft.sqlserver.ManagedDTS)"
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, October 22, 2009 4:28 AM
Points: 173,
Visits: 504
|
|
Hi,
Which version of SQL SErver are you on (SELECT @@version)? There seem to be a bug in earlier builds (http://support.microsoft.com/kb/918222/en-us contains a fix).
Does it always happen, even if you restart SSMS?
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Thursday, March 05, 2009 5:22 PM
Points: 10,
Visits: 107
|
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Sunday, November 01, 2009 8:43 PM
Points: 21,
Visits: 67
|
|
Please can you try out the following:
RUN AT THE COMMAND PROMPT ON SERVER: REGSVR32.EXE dts.dll
You can fing the dll file at the location :\Program Files\Microsoft SQL Server\90\DTS\binn\
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 5:48 PM
Points: 354,
Visits: 424
|
|
vmenon (11/4/2008)
Please can you try out the following:
RUN AT THE COMMAND PROMPT ON SERVER: REGSVR32.EXE dts.dll
You can fing the dll file at the location :\Program Files\Microsoft SQL Server\90\DTS\binn\
Hi,
I had the same problem after I installed SP3 on my SQL 2005 standard edition, Win 2003 server. Your solution works like a charm.
Thanks for the solution !!
\\K
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, July 01, 2009 12:16 PM
Points: 1,
Visits: 1
|
|
| I was having the same problem, and your suggestion solved it! Thanks!!!
|
|
|
|
|
Old Hand
Group: General Forum Members
Last Login: Tuesday, November 03, 2009 5:48 PM
Points: 354,
Visits: 424
|
|
phbianchi (7/1/2009)
I was having the same problem, and your suggestion solved it! Thanks!!!
Glad it helped you !
|
|
|
|
