How to handle this scenario in single SSIS package?

This will help.

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

Browse More Popular Posts

Leave a Comment