64 bit excel connection issue

Question

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.

how to solve without Set Run64BitRuntime to False .

Answer 1

What version of SSIS are you using? What version of Excel are you using? I think there is a 64-bit OLE DB driver for Excel available for download.

---

Kind regards M

Answer 2

yes the excel connection manager is not supported till 2008 R2 (as I know) so set the 64 debug to false in project properties if you are using BIDS 

---

Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

The Excel Connection Manager is not supported in the 64-bit version of SSIS, so to load excel data in the staging tables in 64 bit, you need to do a little trick as below

 

Right click on the properties of ssis project and change the Run64BitRuntime to False, see the attached image and you are good to go.

Answer 3

Vega.. Using SQL Server 2008 R2 Enterprise Edition and source excel version is 2007. Have installed the microsoft access database engine 2010(referred in help sites saying will support 64 bit) but even it throws the same error.

There is a Script task which reads the excel file using the below connection It works fine. but when we run read it from DTF using excel source it throws an error.

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\excel.xlsx;Extended Properties="Excel 12.0;HDR=YES";

One machine which has the same configurations is working for both 32 bit and 64 bit. Not sure what the problem is in another machine.

Answer 4

The version you are referring to should have a 64-bit OLE DB Provider for Excel.

If this a run time error -  i.e., when the package is run through a job, this means that the package is not using the 64-bit driver. You may need to uninstall the 32-bit driver (if it is installed) on the 64-bit machine.

If this is a design time error - i.e., you cannot edit the connection - try Prajesh's suggestion.

---

Kind regards M