Monday, June 9, 2008

Deployment on 64 bit computer


I ran into trouble while deploying packages to the 64 bit system. Packages run perfect in 32 bit dev and 32 bit test environment. The package was delivered as MSI, the installation was successful, but the package was not visible in the UI of Server Mangement stdio, But is available under /90/DTS/Packages/Package
When i tried to execute from here i got the following errors.
DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
DTS_E_OLEDBERROR - "connection timed out"

Found out that the SSIS packages that really don't make use of the 64-bit processor, the SSIS project property Run64BitRuntime can be set to False. The property can be found under SSIS Project Property Pages -> Configuration Properties -> Debugging.
Now the packages run as they did in the test environment.