Excel Connection Manager error in SSIS 2012

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Excel Connection Manager error in SSIS 2012

Excel Connection Manager error in SSIS 2012

Rate Topic

Display Mode

Topic Options

Author

Message

thamilanga

Posted Thursday, September 06, 2012 10:14 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 5:44 AM
Points: 29, Visits: 125

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

Post #1355460

opc.three

Posted Thursday, September 06, 2012 12:09 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:27 PM
Points: 6,735, Visits: 11,788

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1355545

thamilanga

Posted Friday, September 07, 2012 9:05 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 5:44 AM
Points: 29, Visits: 125

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

Post #1356047

thamilanga

Posted Monday, September 17, 2012 3:49 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 5:44 AM
Points: 29, Visits: 125

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

Thanks
Thami

Post #1360061

opc.three

Posted Monday, September 17, 2012 5:36 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:27 PM
Points: 6,735, Visits: 11,788

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1360120

dsouchon

Posted Thursday, October 25, 2012 5:50 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 25, 2012 5:46 AM
Points: 1, Visits: 3

Where is this debug setting re the 64Bit runtime?

Post #1376939

thamilanga

Posted Thursday, October 25, 2012 7:22 AM

SSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 5:44 AM
Points: 29, Visits: 125

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

Post #1376976

mbvnaveen5

Posted Thursday, January 03, 2013 5:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 18, 2013 10:42 AM
Points: 1, Visits: 41

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.

Post #1402308

opc.three

Posted Thursday, January 03, 2013 7:59 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:27 PM
Points: 6,735, Visits: 11,788

mbvnaveen5 (1/3/2013)

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1402397

« Prev Topic | Next Topic »

Permissions