SSIS 2012,Ecel 2010 excel source error connection manager

  • Hi all,

    -----------------------------------------------------------------------------------------

    Could not retrieve the table information for the connection manager 'Excel Connection Manager'.

    Failed to connect to the source using the connection manager 'Excel Connection Manager'

    -----------------------------------------------------------------------------------------

    I am using VS 2010, MS office 2010 & windows 7 64-bit machine. Though i installed the Access db engine 2010 redistributable_x64, i couldn't find these drivers in the list of providers in oledb source.Also, i tried changing the run 64 bit runtime to false, but still the problem persists. Any help will be appreciated. Thanks in advance.

  • This was removed by the editor as SPAM

  • vamsinamburu (3/25/2013)


    Hi all,

    -----------------------------------------------------------------------------------------

    Could not retrieve the table information for the connection manager 'Excel Connection Manager'.

    Failed to connect to the source using the connection manager 'Excel Connection Manager'

    -----------------------------------------------------------------------------------------

    I am using VS 2010, MS office 2010 & windows 7 64-bit machine. Though i installed the Access db engine 2010 redistributable_x64, i couldn't find these drivers in the list of providers in oledb source.Also, i tried changing the run 64 bit runtime to false, but still the problem persists. Any help will be appreciated. Thanks in advance.

    Make sure you have the 32-bit ACE OLE DB drivers installed, as BIDS/SSDT is a 32-bit application.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply