Choosing Bitness Inside Business Intelligence Development Studio

Visual Studio came to a screeching halt when attempting to run an SSIS package the other day, and it turns out that it doesn’t like running in 64-bit, at least when we were using this under Visual Studio 2008.

Therefore, here is some help for those frustrated by this (which, incidentally, feels like something the IDE should know about and just switch on its own)…

Choosing Bitness Inside Business Intelligence Development Studio (BIDS)

If you’re running your package inside BIDS, the setup is simple unless you’re using the Execute Package Task or Execute Process Task to run child packages. The package you currently have open will (by default) run in 64 bit mode.  The setting that controls this is a property on the project called Run64BitRuntime.  To access this property, right-click on the Integration Services project in your solution explorer and select Properties.  Then select the Debugging node in the editor.  The default here is “true”, which means all the packages in this project will run in 64-bit mode.  If you change this to “false”, all the packages will be run in 32-bit mode.

Hope this helps!