SQL Server : Creating an instance of the COM component with CLSID: Problem with creating maintenance plans

While working on a project to configure backup job , I had problem with creating maintenance plans in SQL 2008 R2, x64 as when tried to open maintenance plans got below mentioned error message . Second, it might happen that one can open the maintenance plans wizard, but at the time of submission, same error appears so same can be solved with below mentioned workaround.

 

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)

 

=====================================================================================================================================
Program Location:

 

at Microsoft.SqlServer.Dts.Runtime.Package..ctor()

 

OS: Windows 2008 R2 server SP1 (64bit)
SQL Server: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)

 

Workaround/ Fix :

 

1) Traverse to the C:\Program Files\Microsoft SQL Server\100\DTS\binn directory and run the following from the command:

 

REGSVR32.EXE dts.dll

2) You have to close the SSMS and re-open which will solve the problem.

 

 

 

Brgds, 

Chhavinath Mishra

Database Administrator

Microsoft Certified IT Professional (MCITP)