0

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?

iamdave
  • 12,023
  • 3
  • 24
  • 53
David J.E.
  • 358
  • 4
  • 14
  • IMEX=1 in the connection properties. See https://stackoverflow.com/questions/10102149/what-is-imex-in-the-oledb-connection-string – MiguelH Oct 23 '17 at 11:09

1 Answers1

0

I found the answer myself

Right click on the Excel Connection Manager

enter image description here

And deselect this option

enter image description here

David J.E.
  • 358
  • 4
  • 14