Skip Rows while import using EXCEL Source in Data Flow in SSIS package

Skip Starting rows in Excel Source of Data Flow in SSIS package

  1. Go to the Data Flow tab in SSIS package window.
  2. Click on the EXCEL Source in SSIS package so that right side corner is showing properties window otherwise right click on Excel Source and go to properties.
  3. Go to the property “OpenRowSet” and edit it as:
SheetName$firstRow:lastcolumn


Example: Start to read from line no 9 from column A and my last column is ML
Sheetname$A9:ML

SheetName is the name of sheet which present in Excel.
A9 is the First Row from where you start read the excel file.
ML is the last column which you want to read from the Excel file.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.