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 6, 2012 10:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 15, 2014 1:47 AM
Points: 41, Visits: 169
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 6, 2012 12:09 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
Post #1355545
Posted Friday, September 7, 2012 9:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, August 15, 2014 1:47 AM
Points: 41, Visits: 169
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: Friday, August 15, 2014 1:47 AM
Points: 41, Visits: 169
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: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
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: Friday, August 15, 2014 1:47 AM
Points: 41, Visits: 169
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 3, 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 3, 2013 7:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Saturday, August 23, 2014 8:34 AM
Points: 7,097, Visits: 12,601
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
Post #1402397
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse