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
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: