How to Include Column Headings in Flat File Destination?

• Sid Childers

  Ten Centuries

  Points: 1079

  More actions

  January 16, 2008 at 8:55 am

  #180667

  Good Morning,

  I have created a SSIS package that contains three flat file sources, a union all transformation, and a flat file destination. This is a very basic package: The data from each of the 3 flat files is merged into one larger flat file.

  Question: In reviewing the output, my destination flat file does not contain column headings. How do I ensure that the column headings from my 3 input files are passing into the destination file?

  I apologize if this is a rudimentary question, I'm still learning.....

  Thanks much for your help,

  Sid

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  January 16, 2008 at 9:12 am

  #768753

  In the flat fiel connection manager, select tick box for Column names in the first data row option

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/