column names in first row...with...(do not) overwrite data in the file

• dglane

  SSC Eights!

  Points: 823

  More actions

  July 8, 2009 at 3:22 pm

  #133676

  In my Connection Manager for a flat file, I checked "Column names in first row".

  In my Flat File Destination, I unchecked "Overwrite data in the file".

  I want to append the data into the file (i.e. NOT overwrite) and I want the file to have the header names in the first row ONLY. However, the header names are appearing with every newly appended data set. I did not expect that result. Is that expected behavior? Might I have some other setting wrong? I thought I had this working as desired at one point. Is it possible to achieve the result I want? How?

  Thanks.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  July 9, 2009 at 4:06 pm

  #1022752

  This is duplicate post. The question is being answered here.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/