title: SSIS send ftp files from a list in a text file
body: <p>My job is to get files from an ftp folder, and take only the files that have Day-1 data and send those files to another ftp folder.
  I was told to do this via SSIS.
  Here's what I did :</p>
  <ol>
  <li>Transfer all the files from the ftp to my local machine.</li>
  <li>Get the names of all the files and store them into a sql server Table.</li>
  <li>Check wether the name of the file corresponds to Yesterday's date.</li>
  <li>If so, store the filename in another sql server Table.</li>
  <li>Finally, read the finale sql table, get the rows that contain the name of files to be sent, and sent them.</li>
  </ol>
  <p>I got stuck in Step 5 ! I have no idea what to do I even think there's no way to do it.</p>
  <p>Any ideas ?</p>