Tuesday, July 31, 2012

SQL server 2008 R2 – Maintenance plan Opening issue.

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)

Fix: Easy fix is to apply the  service pack 1. However, if any reason you can’t apply the sevice pack you will need to apply this:

  •     Run cmd
  •     cd C:\Program Files (x86)\Microsoft SQL Server\100\DTS\binn
  •     REGSVR32.EXE dts.dll
  •     Notice the success message.








.

------------------------------------------------------------------------------------------------------------

    No comments:

    Post a Comment