title: Combining multiple flat file into one using SSIS Package
body: <p>I have 2 files, which is data file and trailer file. I would like to combine these files using SSIS package generated by asp.net program.</p>
  
  <p>To combine the two files, i tried Union all but the duplicated rows will be replaced, I also does not wish the data to be sorted like in merge function. Is there any other way i can combine the two files without doing any filtering, just with copy and paste into a new file?</p>
  
  <p>Thanks</p>