Skip Starting rows in Excel Source of Data Flow in SSIS package
Go to the Data Flow tab in SSIS package window.
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.
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.
Smart way of Technology 