SQLTeam.com | Weblogs | Forums

SSIS: exporting to CSV file is missing headers


#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"


#3

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