onlydarksets

Just another WordPress.com weblog

SQL Server Integration Services DTS error

Posted by onlydarksets on March 6, 2008

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”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: