combining the flat file without changing its original spaces between the columns...Spaces are critical

• shrsan

  SSC Eights!

  Points: 900

  More actions

  April 25, 2013 at 1:59 pm

  #292748

  Hi All,

  I have created an ETL process which could delete sapces and have managed to get a flat file with required spaces between the columns (spaces between the columns are not fixed). i have 4 output flat files now i have to union them ( they are of same datatype). i dont want any delimiter in my output i just want to union those flat files.i want the flat files one after the other.

  1) combining the output flatfiles in exact same way.

  2)they must be one below the other eg:1

  ----------------------------------- 2

  ---------------------------------------3

  ---------------------------------------4

  Can Anyone Help Please its urgent!!!

  Thanks:-D

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  April 26, 2013 at 3:08 am

  #1610254

  Use an Execute Process command at the end of your package to run a DOS copy/append:

  copy file1.txt+file2.txt+File3.txt+File4.txt AllFiles.txt

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel