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

Microsoft excel version Expand / Collapse
Author
Message
Posted Thursday, August 30, 2012 6:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346
my excel file has xlsx version.

and i am using visual studio 2005.

it gives me error at excel source connection. what version do i need to choose.
Post #1352175
Posted Friday, August 31, 2012 12:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:15 AM
Points: 13,635, Visits: 11,504
Either convert to 2003 Excel, .xls, or use the following method:

Using Excel 2007 files as a Source in SSIS 2005

Or upgrade to a recent version of SSIS, that's also an option.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1352607
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse