SSIS: exporting to CSV file is missing headers

SSIS and Import/Export
1

I am using SS Data Tools vers 14.

I have a Data Flow task that extracts data from a table then writes it to a flat-file (CSV). The data is exported correctly but the column headers are missing. I tried to see if there was a setting to turn on headers but could not find it.

Would anyone know how to turn on headers?

2

While setting up the destination connection in the File connection manager select the "Column Names in the first Row"

1 Like
3

Thanks ... not sure I know how I missed that.