Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Excel Connection Manager error in SSIS 2012 Expand / Collapse
Author
Message
Posted Thursday, September 06, 2012 10:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, March 22, 2014 6:10 AM
Points: 33, Visits: 142
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
Posted Thursday, September 06, 2012 12:09 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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
Posted Friday, September 07, 2012 9:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, March 22, 2014 6:10 AM
Points: 33, Visits: 142
the file exists locally I've attempted to use different excel extension but error persists.
Post #1356047
Posted Monday, September 17, 2012 3:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, March 22, 2014 6:10 AM
Points: 33, Visits: 142
This error has been sorted. I changed the debug option ‘Run64BitRuntime’ to False and it worked.

Thanks
Thami
Post #1360061
Posted Monday, September 17, 2012 5:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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
Posted Thursday, October 25, 2012 5:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, October 25, 2012 7:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, March 22, 2014 6:10 AM
Points: 33, Visits: 142
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
Posted Thursday, January 03, 2013 5:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 19, 2013 1:34 AM
Points: 4, Visits: 57
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
Posted Thursday, January 03, 2013 7:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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

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 »

Add to briefcase

Permissions Expand / Collapse