title: How to program SSIS to read a bunch of files sequentially in a directory?
body: <p>I'm working on an SSIS package where I need to read several different CSV files in order to insert their data into a SQL Server Database.</p>
  <p>There will be roughly 500 csv files, all in the same folder.  They will have an ordered naming pattern like:</p>
  <ul>
  <li>tFile1.csv</li>
  <li>tFile2.csv</li>
  <li>tFile3.csv</li>
  <li>tFile4.csv</li>
  <li>tFile5.csv</li>
  </ul>
  <p>etc</p>
  <p>How can I program SSIS to automatically start with tFile1.csv, then automatically do tFile2.csv then tFile3.csv etc in order?</p>