Tags

, , ,


Today while creating some jobs on one of the testing server, I faced some unusual error ( Sorry I forgot to take the screenshot of the error, but I am going to give the full details here). Every time I was trying to create or edit any job steps I was getting the below 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)..”

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)

I restarted the SQL Server services but it did not help the cause.

I am also specifying all the configuration here:

I was using Windows Server 2008 R2 Datacenter and SQL Server 2008 R2. I did some research and found out that this is a known issue and this issue comes and goes randomly (that even makes the scenario worse). Microsoft has also identified the problem and it is expected that this will get resolved in the next release. But I have also found a workaround that actually worked for me..I am going to give the details may be it can help you as well

You have to register a DTS.dll. Type the following command in the command prompt:

Type the following command to register the dll with regsvr32 command:

regsvr32 “c:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTS.dll” 

Please change the location accordingly if you have installed SQL Server in any other location. After the .dll was successfully registered I restarted the SQL server services and Voila..It was working again.

Well this worked for me, and I hope this will work for you too.if it does not help then please feel free to let me know I will try to come up with some other solution.

Thanks,

Subhro Saha