September 10, 2014 at 1:32 pm
Does anyone know how to fix this problem?
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.
September 11, 2014 at 12:39 am
dwilliscp (9/10/2014)
Does anyone know how to fix this problem?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.
1) Convert the Excel file to CSV format and import that instead (recommended approach).
2) Try running the package in 32-bit mode and see whether that works.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
September 11, 2014 at 2:02 am
If you are using Excel 2007 or higher, you need to install the 64-bit ACE OLE DB provider.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 13, 2014 at 5:36 pm
Phil Parkin (9/11/2014)
dwilliscp (9/10/2014)
Does anyone know how to fix this problem?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.
1) Convert the Excel file to CSV format and import that instead (recommended approach).
2) Try running the package in 32-bit mode and see whether that works.
I did set BIDS to use 32bit and it does run. Thanks.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply