Post reply

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

  • 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

  • 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

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply