SQL Server Integration Services DTS error
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”
