title: How to detect filename dyanamically in SSIS?
body: <p>I need to convert a flat file to DB using MS SSIS. I need a way to look into a particular folder to fetch the (only) flat file,  filename is of the format "FileName-CCYYMMDD.txt".</p>
  
  <p>Please help me if there is way to add a file from the folder 
  OR
  Get a file name of the format "Filename-CCYYMMDD.txt" where is CCYYMMDD is the current date or maybe CurrentDate -1 according to requirements.</p>
  
  <p>Any code examples or screenshots will be highly appreciated!</p>