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

Question

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?

ScaleOvenStove · Accepted Answer · 2010-07-09 19:13:50Z

1

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

answered Jul 9, 2010 at 19:13

ScaleOvenStove

7601 gold badge7 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SPE109 Over a year ago

Agreed. Then send the first 4 rows to the trash destination konesans.com/products/trash-destination.aspx

DavidStein Over a year ago

Are you asking me to add a column for Row Number in the Spreadsheet?

Collectives™ on Stack Overflow

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

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related