I'm trying to do use the SP on a Standard Edition 2005 SQL Server that can't be upgraded to 2008 R2 yet. You can't set the run in 32 bit mode on the job, so I can't do run my package via a job currently. I updated the package to not be 64 bit and uploaded it to the server.

I'm able to run the package manually on the server, and if I open integration services and run the package on the server it works... but this SP gets the same errors as calling it via a job 🙁

ugh...

Not sure what to do here as drivers for this connection are only 32 bit.

Any suggestions?

Thanks,

Linda