• sunder.mekala (2/19/2013)


    FYI, No Sorting requirements, and flat file formatting is delimeter, Thanks.

    I don't know what you mean when you say "..flat file formatting is delimeter," but from what I can gather, it seems that my initial suggestion would still give you what you need.

    I think that this would also work - and if your coding skills are not up to it, you might prefer it:

    1) Create five data flows to create 5 separate flat files. These could run in parallel in your package, in a sequence container.

    2) Create a final execute process task which runs a batch file.

    3) In the batch file, write a simple copy statement along the following lines:

    copy file1.txt+file2.txt+file3.txt+file4.txt+file5.txt allFiles.txt

    Now your allFiles.txt file contains all output from the other files.

    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.