SSIS run64bitruntime on 64 bit

Question

I developed an SSIS package on a 32 bit machine using Microsoft Visual Studio Ultimate 2012 Trial Version, I've deployed this package to a 64 bit machine for processing. I'm unable to change the run64bitruntime to true, this field is disabled and I can't change it to true. How do I enable this field so that I can be able to change it to true.

Answer 1

Maybe someone will find this useful...

It is possible to change run64bitruntime parameter on execution environment (SQL Server Job) through:

SQL Server Agent->Jobs->Job Step Properties->General->Execution Options

Answer 2

The SSIS development environment is a 32-bit environment. At design time, you only have access to 32-bit data providers, and as a consequence you can only enlist those 64-bit providers in your SSIS projects that also have a 32-bit version available on the development machine.

The SSIS execution environment, on the other hand, is dictated by the underlying oper-ating system, which means that, regardless of the version of the provider that you used at design time, at run time the correct version will be used. This is true when the package is run by the SSIS service as well as when you run the package yourself from SSDT

So, you can control the version of the providers to be used explicitly, via the Run64BitRuntime project setting ONLY at design time.