Excel Data Source Fails

  • 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.

  • 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

  • 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

  • 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