Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sg2255551
Constraint Violating Yak Guru
274 Posts |
 Posted - 2011-02-11 : 22:12:07
|
| hiI am using SQL 2008 R2 Standard editionThis is the following result I found when I try to edit the job step.Job -> right click -> Properties -> job step -> editWhat 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)" |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-11 : 22:24:44
|
I remember getting it once, and restarting SMSS resolved it...I think I ended up rebuilding the job from scratch because it was a file system SSIS package execution steprelevant link:http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-stepsrelevant quote:First, did anyone run into this issue on 32 bit Windows?If you are running 64 bit machine, to register dts.dll for 64 abd 32 bit, you may run the following,c:\windows\system32\regsvr32 "c:\Program Files\Microsoft SQL Server\100\DTS\Binn\dts.dll"c:\windows\syswow64\regsvr32 "c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dts.dll"The first command registers 64 bit DTS.dll, and the second command registers 32 bit. SSMS is 32-bit.Thanks,
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
|
|
|
Edit Job Step Error