My situation is similar. My SSIS package works fine from local computer but when I try to run it from SQL Agent Job it fails with the following error:

Message

Executed as user: NYC\NYCSQL. ...Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:17:10 PM Progress: 2008-08-18 17:17:10.57 Source: Load Output From BO Excel into Hub_MEM Validating: 0% complete End Progress Error: 2008-08-18 17:17:10.66 Code: 0xC0202009 Source: Load_MEM_Hub Connection manager "Excel Connection Manager 1" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2008-08-18 17:17:10.66 Code: 0xC020801C Source: Load Output From BO Excel into Hub_MEM Excel Source [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager 1" failed with error ... The package execution fa... The step failed.

My steps are as below:

1. Run a Webservice to generate an excel file - This step completes successfully

2. Data Flow - Excel Source - Succeeds

3. Data Flow - Load Excel file into SQL05 table - This is where it fails

My connection managers are "Excel Connection Manager 1" has "Provider=Microsoft.Jet.OLEDB.4.0" setting.

I am still getting this error. I think there is some setting I am missing. Grasshopper, please help!

Thanks