Export Flat File Without Header in SSIS Package


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.

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s