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?

Answers


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


Need Your Help

How do I append data from a child item in Firebase database?

ios xcode firebase firebase-realtime-database collectionview

How do I append data from a child item in Firebase database? Below is my code.

How do you make javascript code execute *in order*

javascript ajax order-of-execution

Okay, so I appreciate that Javascript is not C# or PHP, but I keep coming back to an issue in Javascript - not with JS itself but my use of it.