Hello Solution Providers:
When attempting to execute a SSIS package as a scheduled job I receive the following error. I am moving data from SQL Server to an Access database. The package executes successfully when run from Business Intelligence Development Studio.
Source: Package1 Connection manager "DestinationConnectionOLEDB"
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: 2013-09-18 12:22:57.85
Code: 0xC020801C Source: Data Flow Task Destination - ccmbranr 
Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB"
failed with error code 0xC0202009.
The destination oledb is the Access database on a file share. There is no password on this Access Database. SQL Server Agent account has permissions on the destination directory. Do you have any suggestions?
Maricopa County DBA