Export Flat File Without Header in SSIS PackagePosted: March 7, 2017
When export flat file through bcp, it will take some efforts to add the header row.
This is very easy to hide it from SSIS Flat File Connection.
In SSIS package, we can define a property from Flat File Connection to set “ColumnNamesInFirstDataRow” to “False”.
The result flat file will have data only without hearder row.