Greg --

This sounds like an issue in the way the package is being executed and the drivers being used. You may want to try something like below in your SQLAgent job used to execute the SSIS package.

Your job step would be an Operating System task (cmdexec) rather than SSIS package task. Adapt the command below to suit your needs. The command below assumes the package is stored in msdb.

C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe /SQL "\SSISSubfolder\YourSSISPackage" /SERVER YourServerNameHere /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

Hope that helps.

Nivek