how to run ssis package in 32 bit mode
Best answer To set this option you must open the job and edit the job step for your SSIS package. Then navigate to the Execution Options taband select the Use 32 bit runtime check box. Just like the SQL Agent job,your Visual Studio will likely need