Thursday, October 11, 2012

Creating an instance of the COM component with CLSID

We may get the below error when we are trying to edit the job steps created earlier.

Creating an instance of the COM component with CLSID {B380D7F6-CAEF-4A56-B9BB-FOF3CD976AA2} from the IClassFactory failed due to the following error: a101d110. (Microsoft.SqlServer.ManagedDTS)

To fix the issue we need to re-register the dts.dll

From command prompt
c:> regsvr32.exe dts.dll

Hint : Browse dts.dll in Microsoft SQL Server\version number\DTS\binn

No comments: