SSIS generating csv file without headers

Question

I’m making an SSIS package to create a CSV file using OLE DB Source and Flat File Destination.

When I get the file it doesn't contain the headers but they are clearly defined in the destination.

I've tried all the options related to this:

• headers rows to skip -1,
• column names in the first data row,
• column delimiter,
• data rows to skip
• and even resetting the columns.

Answer 1

Please check the option in the Flat file connection manager as

Just in case this doesn't work then the setting are not being carried over to your config files. In such cases there are two workarounds:

1. Editing the .dtconfig to edit "firstcolumnhasnames" to 1 adds the column names without needing to delete the connection from the package.
2. delete the destination connection, and recreate from scratch.