SSIS – How To Read Excel Data From Nth Row

SSIS – How To Read Excel Data From Nth Row

Today we will see how we can read excel data from nth row using SSIS Excel Source.
Recently while I was working with Excel source, I was faced with the problem where I need to read data from excel file but not from 1’st row .the actual data starts from the 4’th row which I need to read.
In short, I need to skip the first 3 rows from excel file and read data from the 4’th row. let me describe how we can do read data after skipping no of rows.
First, add a new Data flow task and add Excel Data Source. 
ExcelSource
Add data source and select the excel file which we want to read data from the file.
Right click on Excel Source click on Properties. Go to Custom Properties and go to OpenRowset and set value toSheet1$A3: M (M will be second value till data should read).
datasourceproperty
Now we can see output using multicast excel data. The same property can be set up programmatically using Script Component.

Share this post

Leave a Reply

Your email address will not be published. Required fields are marked *