I have an SSIS package set up that runs a stored procedure that populates a table, and then exports the table data to Excel. The package runs just fine if I execute it from Visual Studio. I have the package deployed to SQL Server (msdb table) with the protection level set to rely on the server and roles for access control.

I created a scheduled job in SQL Server with one step -- to run the SSIS package. When I try to execute the job I get the error below. Again, this only happens when I try to run the package as a job.

Error: 2009-02-11 10:27:21.24 Code: 0xC0202009 Source: Equipment_Counts_by_Zone Connection manager "Excel Connection Manager" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x800... The package execution fa... The step failed.

Can someone help my pinpoint the cause of this error and what to do to correct it?