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?
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