title: SSIS Wildcard Flat file connection
body: <p>I want to load data from some csv files in a certain directory into a sql server table. The files are in the following format File_DDMMYYYHHMMSS.csv however I only want to select the files from the current day, the time doesn't matter. Is there a way to search files in this way? 
  I have tried using a foreach loop and looking for only *.csv and setting a variable and then using:</p>
  
  <pre><code>LEFT(  @[User::FileName],5 ) +  
  RIGHT("0" + (DT_WSTR,2)DatePart("dd", GetDate()), 2) +
  RIGHT("0" + (DT_WSTR,2)DatePart("mm", GetDate()), 2) + 
  RIGHT((DT_WSTR, 4) DATEPART("yyyy", GetDate()), 4)
  </code></pre>
  
  <p>What i need is something like :</p>
  
  <p>@filename + Todays date + "<strong>__</strong>"</p>