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"