SSIS Excel Import - First row getting skipped I am using VS 2017(SSDT) with SSIS(2012). I'm trying to import an Excel file, but the issue is that the first row is getting skipped.
I've unchecked First row has column names in Excel Connection Manager, but in vain.
Please advice on how to import the first row.
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...