title: SSIS processing large amount of flat files is painfully slow
body: <p>From one of our partners, I receive about 10.000 small tab delimited text files with +/- 30 records in each file. It is impossible for them to deliver it in one big file.</p>
  
  <p>I process these files in a ForEach loop container. After reading a file, 4 column derivations are performed and then finally contents are stored in a SQL Server 2012 table.</p>
  
  <p>This process can take up to two hours.</p>
  
  <p>I already tried processing the small files into one big file and then importing this one in the same table. This process takes even more time.</p>
  
  <p>Does anyone have any suggestions to speed up processing?</p>