Tag Archives: BIDS

Error moving SQL Server Integration Services (SSIS) package to a 64bit server

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

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"