title: SSIS Expression - get the next characters
body: <p>I need to get the exact file name of a txt file as the connection string of my flat file connection manager. I have used the following expression:</p>
  
  <pre><code>@[User::DataLoadDir]+"Myfile_" +  (DT_STR, 4, 1252) YEAR (getdate()) + RIGHT ("0" + LTRIM ((DT_STR, 4, 1252) MONTH (getdate())), 2) + RIGHT ("0" + LTRIM ((DT_STR, 4, 1252) DAY (getdate())), 2) + ".TXT"
  </code></pre>
  
  <p>That returns </p>
  
  <pre><code>C:\Mypath\Myfile_20131203.TXT
  </code></pre>
  
  <p>But actually my filename has additionaldigits after the dates. 
  It is </p>
  
  <pre><code>C:\Mypath\Myfile_20131203034537.TXT
  </code></pre>
  
  <p>What change should I do on my current expression? Is there something like putting * to indicate that it should accept any characters?</p>