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

Error:

I was running a SSIS package in MS visual studio and I got the below error message:

“SSIS package "Package.dtsx" starting.

Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.

Error: 0xC00F9304 at Package, Connection manager "Excel Connection Manager 2": 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.

Error: 0xC020801C at Data Flow Task, Excel Destination [28]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "Excel Connection Manager 2" 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 Data Flow Task, SSIS.Pipeline: component "Excel Destination" (28) failed validation and returned error code 0xC020801C.

Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.

Error: 0xC0024107 at Data Flow Task: There were errors during task validation.

SSIS package "Package.dtsx" finished: Failure.”

What is the reason? The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

Resolution: We need to execute our package using the 32-bit SSIS runtime.

I set the 32-bit SSIS runtime system using below procedure:

Click on Project->Project Properties

Then Debugging -> Run64BitRuntime = False

 

Now click Apply and OK.

 

I re-execute the SSIS project and it completed successfully.

 

 

• Tweet
• Share
• Share
• Share
• Share