Excel Connection Manager error in SSIS 2012

  • Please assist with error below:

    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'

    This error occurs when I try to select the Name of the Excel sheet in the SSIS 2012 Excel Source Editor. I'm on a 32bit machine.

    Thanks

  • Does the file referenced by the Excel Connection Manager exist?

    __________________________________________________________________________________________________
    There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

  • the file exists locally I've attempted to use different excel extension but error persists.

  • This error has been sorted. I changed the debug option ‘Run64BitRuntime’ to False and it worked.

    Thanks

    Thami

  • Thanks for posting back the root cause so others can benefit. The Excel driver built-into SSIS is a 32-bit Jet 4.0 driver which cannot be used in 64-bit mode so your resolution makes a lot of sense. In case you prefer to have all your packages execute in 64-bit mode you can switch your package to use the newer ACE drivers which support accessing Access and Excel 2010 files in 64-bit mode:

    Microsoft Access Database Engine 2010 Redistributable (includes ACE OLE DB Driver 12.0)

    __________________________________________________________________________________________________
    There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

  • Where is this debug setting re the 64Bit runtime?

  • I'm not confront of my machine right now but under solution explorer if you right click on the solution name and select properties you will see it on the top left of the properties screen

  • i changed the option Run64BitRuntime to false but still i am getting "could not retrieve the table information for the connection manager .Failed to connect to the source using the connection manager '' error.....

    i am using ssis 2012.

  • mbvnaveen5 (1/3/2013)


    i changed the option Run64BitRuntime to false but still i am getting "could not retrieve the table information for the connection manager .Failed to connect to the source using the connection manager '' error.....

    i am using ssis 2012.

    Please start a new thread. Preferably in either the SQL 2012 General or the Integration Services Forum.

    __________________________________________________________________________________________________
    There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Viewing 9 posts - 1 through 9 (of 9 total)

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