title: SSIS Export all data from one table into multiple files
body: <p>I have a table called customers which contains around 1,000,000 records. I need to transfer all the records to 8 different flat files which increment the number in the filename e.g <code>cust01</code>, <code>cust02</code>, <code>cust03</code>, <code>cust04</code> etc.</p>
  
  <p>I've been told this can be done using a for loop in SSIS. Please can someone give me a guide to help me accomplish this.</p>
  
  <p>The logic behind this should be something like "count number of rows", "divide by 8", "export that amount of rows to each of the 8 files".</p>