File System Task - Combine multiple Flat Files into one

• jpalmer-755805

  SSC Eights!

  Points: 959

  More actions

  December 14, 2009 at 2:45 pm

  #137672

  Hi,

  I need to create 6 seperate flat files that each have their own format:

  File 1 - 01 - Header

  File 2 - 02 - Detail 1

  File 3 - 03 - Detail 2

  File 4 - 05 - Detail 3

  File 5 - 06 - Detail 4

  File 6 - 99 - Trailor

  Then combine them into 1 file - Unum.txt

  Any advice would be appreciated.

  Thanks,

  Jeff

• sabyasm

  SSCarpal Tunnel

  Points: 4324

  More actions

  December 14, 2009 at 3:53 pm

  #1092281

  [font="Comic Sans MS"]

  You can do the same using a script task within a for each loop container.. for the code you can google or refer here (similar code):

  http://vbadud.blogspot.com/2007/12/combining-text-files-using-vba.html

  or

  http://www.daniweb.com/forums/thread166200.html#

  or

  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/d70bd8b9-d3b1-4ba3-b37a-6ddefddd45ec

  (use dos code)

  COPY a.txt+b.txt destination.txt

  [/font]

  [font="Comic Sans MS"]--
  Sabya[/font]