Open the SQL Agent job and the step where you call the SSIS Package.

On the "Execution Options" tab...check the box "Use 32 bit Runtime" and see what happens. When using Excel or some ODBC drivers you need this setting to emulate the 32-bit environment or the job will fail.

-Eric