As most new PCs are shipping with a 64-bit OS this is becoming a more common error. I always forget how to resolve this and have to look it up so I thought if I wrote about it in a blog it would help me remember. So you build your data flow in SSIS, get everything converted and mapped. Time to test it in Visual Studio and then the dreaded error –
[Excel Source ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC00F9304. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
[Connection manager “Excel Connection Manager”] Error: SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.
This issue is easier to resolve than it might appear. To fix it go into the project’s properties and select Debugging.
You should see Run64BitRuntime set to True.
To fix the problem just set it to false. Problem solved.