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.