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 [1]: 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 ‘[4972] 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

When I open the SSIS project from I can see the following error from the “Error List” Panel

‘Error    1    Validation error. Export Data Flow Task1: Package1: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: “Microsoft OLE DB Provider for SQL Server”  Hresult: 0x80004005  Description: “[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.”.      Package1.dtsx    0    0    ‘

I am wondering why SQL Server access denied, at the end, I realise the SQL service do not start automatically.

TO solve it I just need to
“Start” -> “Control Panel“-> “Administrative Tools“-> “Services“
Then select the SQL Server instance that you want to start up the service.
Right click on it and select “Start“.

Then you may want to close down the project and re-open it again.
The error message should disappear.