Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Microsoft excel version Expand / Collapse
Posted Thursday, August 30, 2012 6:59 AM


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



Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 15,510, Visits: 13,170
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 SQLKover.

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

Add to briefcase

Permissions Expand / Collapse