Posted by & filed under Web Development.

This week one of our database servers was upgraded to a 64bit Windows platform.  Everything seemed fine until I went to execute an SSIS package.   I opened the package with dtexecui.exe and received the following gift after hitting the execute button.

The new connection manager could not be created.
Additional information: Exception from HRESULT: 0xC0010014
(Microsoft.SQLServer.DTSRuntimeWrap)

After much searching, installing Business Business Intelligence Development Studio (BIDS) to debug, and heartache I ended up finding a form post entitled “MS SQL 2005 SP2 x64 & SSIS Packages” about several key DLLs that may not have been properly registered at setup.  This saved my day!  I registered the problem child DLL using the following command and life was good again.

regsvr32 "\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTS.dll"

One Response to “Error moving SQL Server Integration Services (SSIS) package to a 64bit server”

  1. Chris

    Thank you, Mr. Jackson. This same problem was kicking my ass until I found your post.

Leave a Reply

  • (will not be published)