Error with creating maintenance plans

Issue:

There are situations where a COM related error thrown while creating maintenance plan in SQL Server SSMS.

Error Message:

=======================================================================

==============================================================

Creating an instance of the COM component with CLSID {17BCA6E8-A95D-497E-B2F9-

AF6AA475916F} from the IClassFactory failed due to the following error: c001f011.

(Microsoft.SqlServer.ManagedDTS)

  

Step 1:

Traverse to the C:\Program Files\Microsoft SQL Server\100\DTS\binn directory and run the

Following from the command Prompt:

REGSVR32.EXE dts.dll

Step 2: 

Once done with registering the dts.dll you will get an successful information.

Step 3: You have to close the SSMS and which will solve the problem in creating the maintenance problem.

  

Maintenance plan will be created without any issues once the above troubleshooting is performed.

To study more about COM Class object and CLSID's Click Here

Appreciate your suggestions. Please comment your feedback and reach me out via email

Regards,

Ganapathi varma

Senior SQL Engineer, MCP

Reference: (http://mssqllover.blogspot.in)

Linkedin