SQLTeam.com | Weblogs | Forums

SSIS: exporting to CSV file is missing headers


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?


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


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