title: Renaming a file source
body: <p>I've been developing an SSIS package from a flat file source. The file comes daily and the file name has datetime indication like this: </p>
  
  <p>Filename_20190509042908.txt </p>
  
  <p>I was wondering how I can pass until the date part; I want the package to read the file dynamically, but it should pass without the last 6 digits I just don't need the last 6 digit numbers as it is not consistent. </p>
  
  <p>I want to pass Filename_20190509.txt</p>
  
  <p>I have figured out how to take the filename until date removing the time part. Hence, I've trouble to let the package read the file name dynamically by ignoring the last 6 digits before file extension. </p>
  
  <p>Can anyone help me with this please?</p>