SSIS Excel Import - First row getting skipped
This is very easy using the Wizard:

In your Project, drag a data flow task onto the board



Double-click the data flow task. being inside the data stream, drag an excel source.



then we create a new connection to excel by clicking on excel source.



we look for the excel file that we want to import and select: &quot;the first row has column names&quot;



we select the table or the view that we have in the excel sheet.



With this we would already have the process to import the excel data to any destination ...


good Luck...