Thursday, July 21, 2011

Microsoft SQL Server Management Studio - Error while create or edit job steps

Error :-
TITLE: Microsoft SQL Server Management Studio
------------------------------

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

------------------------------
ADDITIONAL INFORMATION:

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

------------------------------
BUTTONS:

OK
------------------------------




http://connect.microsoft.com/SQLServer/feedback/details/557402/ssms-can-no-longer-create-or-edit-job-steps


Posted by Ewan on 5/10/2010 at 3:59 AM
I registered the DTS.dll (using regsvr32) in \Program Files\Microsoft SQL Server\100\DTS\Binn and restarted SSMS and the problem has gone away
Posted by Ewan on 5/26/2010 at 1:20 AM
As Aaron points out, this workaround is invalid - it's the SSMS restart which fixes the bug temporarily. No way to delete the workaround entry, so thought I'd post a correction.
Posted by lex3001 on 11/22/2010 at 11:28 AM
I didn't see this at first but this is fixed in Cumulative Update 3. http://support.microsoft.com/kb/2315727
Posted by subha.mcts2005 on 1/3/2011 at 5:59 AM
Hi ,

iam getting same the problem in my SQL server 2008 R2 EE.

plz help me
Posted by Kastanjehoeve on 3/10/2011 at 3:03 AM
Solved the issue by setup/repair (shared features only). No need to reboot.

No comments:

Post a Comment

FEEDJIT Live Traffic Map