Column Names in SSIS Output

• AMCiti

  SSC-Addicted

  Points: 485

  More actions

  April 1, 2021 at 8:36 pm

  Go to Answer

  #3864567

  Dear Group:

  My apologies if this is not the place for this question, but I wasn't sure where to ask an SSIS question, but we are using SQL Server 2014, so I thought this would be the place.

  I have an SSIS package that exports a query to a Flat File, using the Flat File Connection Manager (FFCM). I need to include the columns as the first row in the export, and the only way to do this that I have found is going into the FFCM Manager Editor, going to the General Options and clicking the "Column Names in the First Data Row", and then having to go into the Advance portion and manually entering all column names.

  Is there no way to include the column headings without such a manual process?

• Mike01

  SSChampion

  Points: 11381

  More actions

  April 2, 2021 at 2:52 pm

  Answer

  #3864787

  All you need to do is check the Column Names in first data row box.  I created a new SSIS package to test it.  Created both source and destination connections with that box checked and the first row was column names

  For better, quicker answers, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/