Integration Services Throws an Error Reading Access 2007 Table

Question

[Participant Table [1994]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "I:\My Documents\Flamm Consulting\Migrations.accdb" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Frankly, I'm confused about how SSIS should connect to Access 2007 - the UI just isn't very friendly - there's no file browser, for example. I'm wondering if there's something wrong with my install - missing drivers, etc.

Answer 1

Two guesses - first, you're attempting to run this package on a 64-bit server, which isn't going to work without a tweak. Second, you don't have the drivers installed.

For info on the first, try here: SSIS in 32- and 64-bits. For info on the second, try here: Interacting with Office in SSIS.