Error moving SQL Server Integration Services (SSIS) package to a 64bit server
May 23rd, 2009
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"
