SSIS generating csv file without headers
<p>I’m making an SSIS package to create a CSV file using <code>OLE DB Source</code> and <code>Flat File Destination</code>. </p>

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

<p>I've tried all the options related to this: </p>

<ul>
<li>headers rows to skip -1,</li>
<li>column names in the first data row, </li>
<li>column delimiter, </li>
<li>data rows to skip </li>
<li>and even resetting the columns. </li>
</ul>