Creating Header and Footers in export files

• beath

  SSCrazy

  Points: 2939

  More actions

  October 11, 2007 at 5:40 am

  #153886

  Hi

  I have a simple table with 4 columns that I need to export to a text file using SSIS - no problem there. But I also want to create the file with a header and footer. The header contains some static data and the date and the footer contains the number of records.

  In DTS I had some ActiveX scripts to export the header, data, and footer to 3 separate text files then used more scripts to append the 3 of them together. Failrly chunky I know but it works. I'm thinking there must be a much nicer way to do this in SSIS but I'm not sure what.

  cheers

• Mike Bishop

  SSC Eights!

  Points: 964

  More actions

  October 12, 2007 at 6:32 pm

  #741762

  Hi - No I don't think so. What I see are 3 related tasks in the control flow. The middle one is the data flow that appends to file created by first task - A script task but you get to write it in vb.net - that writes the header. The 3rd task is also a script task; it appends the footer.