CODEWITHSUNDEEP
excelsql-server-2008ssis
DavidStein
DavidStein

Reputation: 3189

Importing Multiple Tables from Excel Using SSIS 2008 - Skipping Rows with ADO.Net Source

I have created a SSIS 2008 Package which imports rows from a spreadsheet. I need to start on row 4 so I have used the OpenRowset property of the Excel connection manager.

However, I need to import multiple tables. Can this be done with the Excel Connection Manager?

I believe it can be done with an ADO.Net Source, but I don't know how to skip rows using that.

Can anyone point me in the right direction?

Upvotes: 0

Views: 535

Answers (1)

ScaleOvenStove
ScaleOvenStove

Reputation: 760

any way you can add a rownumber on your datasource? then as you pull data from your datasource in SSIS, you can conditonally split on rownumber < 4

Upvotes: 1

Related Questions