Ok, got the permissions needed for the SQL Agent service account and the package still fails. I'm left to take the error message literally....that there is some missing driver/software on the server that's needed to connect to (and read from) the MS Access DB (based on the mention of, "Class Not Registered" and failed Method Call to "AcquireConnection").
Anyone have any advice?
Here's the error message in detail (spacing added):
Executed as user: MYDOMAIN\!mySqlAgent. ...0.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 9:56:42 AM
Error: 2008-07-28 09:56:44.37
Code: 0xC0202009
Source: ABC_Refresh Connection manager "ABC_Interface.mdb"
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-07-28 09:56:44.37
Code: 0xC020801C
Source: Synch ABC_SynchStage MS Access tblABC_Details [13]
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ABC_Interface.mdb" failed with error code 0xC0202009. There may be error messages posted before this with m... The package execution fa...