title: SSIS- Split output into multiple files
body: <p>I am using SSIS Data Tools to create data extracts from a legacy system.
  Our new system needs the files that it imports to be split into 5MB files.</p>
  
  <p>Is there anyway that I can split the files into separate files?
  I'm thinking that because the data is already in the database, I can do a loop, or something similar, will select a certain amount of records at a time.</p>
  
  <p>Any input appreciated!</p>