Set no use headers and take the first row as a normal row in an Excel source file that have no headers

Question

I'm trying to get the first row from an Excel worksheet in a data flow task using SSIS. My Excel source file doesn't have headers but SSIS always uses the first row as headers. How can I tell SSIS there are no headers in the Excel file?

IMEX=1 in the connection properties. See stackoverflow.com/questions/10102149/… — MiguelH

David J.E. David J.E. · Accepted Answer · 2017-10-25T10:23:49

0

votes

I found the answer myself

Right click on the Excel Connection Manager

And deselect this option

Set no use headers and take the first row as a normal row in an Excel source file that have no headers

1 Answers