Set agent job step to run in 32 bit mode

SSIS can prove challenging when dealing with 32/64 bit issues. You might run into an issue where the job will not run correctly and it may have to do with the fact that the job needs to run in 32 or 64 bit mode.

Microsoft has not made it simple to find how to change an agent job. I hope the below images will prove helpful.

Step 1

Step 2

Step 3

Step 4

Step 5