Worked in Database technology for fixed the issues faced in daily activities in Oracle, MS SQL Server, MySQL, MariaDB etc.
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
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:
Example: Start to read from line no 9 from column A and my last column is 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.