Fix for SSIS Error 0xC0209303

When using BIDS to create an SSIS package in a 64-bit environment it was easy to create the connection to a 32-bit Access Database. You can view and select columns from the database, modify them in the data flow, then map them to the destination table.

But when you execute the package you get an errorĀ 0xC0209303 which says the Access DB couldn’t be opened.

The quick fix: Under the Project menu pick the project Properties (bottom choice), pick Debugging under Configuration Properties, and set the Run64BitRuntime property to false.