SQL Server Integration Services DTS error

March 6th, 2008 | Categories: Applications | Tags:

I was getting the following error when trying to create a new SSIS Package in MS SQL Server 2005 Integration Services:

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: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))..

It turns out the DTS component wasn’t properly registered.  I found the command line to fix it:

regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”

No comments yet.