The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC00F9304

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

23 thoughts on “The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC00F9304

  1. Cooper

    Thanks your information. But when I try to schedule it, I encounter same error message. Do you have any experience in that? Please advise and thanks your help.

    Reply
  2. Cooper

    I got the answer. To fix this issue is select Use 32 bit runtime on the Execution options tab of the New Job Step dialog box.

    Reply
  3. joel

    i cannot believe that this was not thought out to be a little more user friendly. Thank you for the fix, it saved a lot of people! I am just wondering what i would need to have for this to work without implementing your fix. Install excel 64 bit on my machine ?

    Reply
  4. Vivek

    everyone suggesting the workaround for executing in command prompt and running in Agent job. but this step helps a lot to debug., thanks., keep it up

    Reply
  5. Balaji B

    I feel ashamed to tell you all that I spent about 40 frustrating hours to solve this issue. But could not. However, I found a workaround for this.

    This issue occurs whhen you enable package configurations. In that case, you need to manually modify the connectionstring and add the Password=myPassword; to it and then execute the packages. IT WORKS..

    Reply
  6. saltamuros

    Thanks!!!! I knew about the BID debugging option but not about the job tab. Great.

    Reply

Leave a Reply