When I try to use SSIS to import data from Excel to Database, it has failed and return the error message below.
“The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC00F9304“
SSIS package “ShareChiWai.dtsx” starting.
Information: 0x4004300A at Import So from Excel, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC020801C at Import So from Excel, Standing Order Excel File : 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.
Error: 0xC0047017 at Import So from Excel, SSIS.Pipeline: component “ShareChiWai Excel File” (1) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Import So from Excel, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Import So from Excel: There were errors during task validation.
SSIS package “ShareChiWai.dtsx” finished: Success.
The program ‘ ShareChiWai.dtsx: DTS’ has exited with code 0 (0x0).
I have done some research related with the error code 0xC00F9304. It said:
“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.“
Fortunately, I have worked out how to solve this issue: [because I have similar issue before with Visual Studio after upgrading the operating system to 64bit…]
Here it is my solution:
Right click on your SSIS project in your “Solution Explorer”
Then Select “Properties”
On the “Property Pages” click on “Debugging”
and Under “Debug Options” ->”Run64ButRuntime”
Switch it from “True” to “False”
so that the project will not start 64 bit SSIS runtime, even 64 bit SSIS runtime is installed. [This mean it will use the 32 bit runtime]
Hope you find it useful