Tuesday, September 11, 2012

Issue 1 :- Not able to edit the maintenance plan and getting error.

Error :- 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)

Solution :- Register the DTS.dll (using regsvr32) in \Program Files\Microsoft SQL Server\100\DTS\Binn and restarted SSMS and the problem has gone away.

No comments:

Post a Comment