[Solved] How to handle this scenario in single SSIS package?


This will help.
how-to-read-data-from-an-excel-file-starting-from-the-nth-row-with-sql-server-integration-services

Copying the solution here in case the link is unavailable

Solution 1 – Using the OpenRowset Function

right click on the Excel Source and select Properties

modify the OpenRowset property

Solution 2 – Query Excel Sheet

Edit the connection manager and change the data access mode to SQL Command

Solution 3 – Google It

Google it, The information above is from the first search result

3

solved How to handle this scenario in single SSIS package?