SSIS Flat File Wildcard Filename
===

I want to load a .csv file that is dropped in a specific directory but the filename is suffixed with YYYYMMDD, eg. MyFile_YYYYMMDD.csv.  

The directory is cleared out everyday and a new file is dropped, ie. there is only ever 1 file in the directory.

Is there a (simple?) way to code a wildcard filename, eg. MyFile_*.csv, that can be used by the Connection Manager without having to use a Foreach Loop Container or a Script?