Executing a 64 bit SSIS package within 32 bit environment

Few days ago  I encountered this situation. In fact, I have developed a package within 64 bit machine, but I was in situation that I have to execute that given package in a 32 bits environment. Of Corse, I tried several methods like rebuild the package within a 32 bit environment. But there is a tricky way to do so, if you have a SQL Server Management Studio 2008.

Start the SQL Server Agent

       

 

Then add a job step and precise that this last one will execute a  SSIS package

The next step is to indicate the package location. As we know, an SSIS package could be stored within msdb SQL Server data base, the file system or SSIS package store.

After configuring the package location within the Job Step page, press the Execution options tab which is the before last one in the same Job Step page

 In this way we guarantee that the given package will be executed in 32 bit environment, in spite of the fact that it was developed and built within 64 bit environment.