Wednesday, July 22, 2015

Read and Export Excel data from nth Row in SSIS

This post shows how we can read and export data from excel starting from nth row.


In SSIS we can read excel data starting from any number of row. Considering a scenario we have a excel file like below screen and we need to read data of Row 2 to Row 15.
To do this I create an Excel Connection manager in my SSIS package. I created a Data Flow Task in the control tab. On Data Flow tab I have following components. 


Right Click on the Excel Source and select properties.

In the OpenRowset you will find the sheet name from which you are extracting the data. You have to make modification here to read the data from the nth row or range.

As you can see from the below Image I have already updated the OpenRowset value to
Sheet1$A2:A15


Now double click on the excel source and click on preview button, as you can see from the below Image data was read from the row 2 to row 15.


I hope you enjoyed the article don't forget to share on Facebook. Please leave your comments below if there are any questions.