Thursday, August 2, 2012

Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}' failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155). (Microsoft.SqlServer.ManagedDTS)

I got the issue when i hit edit button in the job step.


The issue may cause due to some issue with installation. But it is clearly stating interface is not registered.

Search for dts.dll file in DTS folder of Microsoft SQL Server

c:\program files\microsoft sql server\90\dts\binn\dts.dll

c:\> regsvr32 c:\program files\microsoft sql server\90\dts\binn\dts.dll

By registering the dll will fix the issue

No comments: