Post reply

Excel Connection Manager error in SSIS 2012

  • September 6, 2012 at 10:14 am

    #393119

    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

  • September 6, 2012 at 12:09 pm

    #1534690

    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

  • September 7, 2012 at 9:05 am

    #1535118

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

  • September 17, 2012 at 3:49 am

    #1538474

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

    Thanks

    Thami

  • September 17, 2012 at 5:36 am

    #1538529

    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

  • October 25, 2012 at 5:50 am

    #1552648

    Where is this debug setting re the 64Bit runtime?

  • October 25, 2012 at 7:22 am

    #1552684

    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

  • January 3, 2013 at 5:31 am

    #1573265

    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.

  • January 3, 2013 at 7:59 am

    #1573342

    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 8 (of 8 total)

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