I'm trying to setup a FTP task with SSIS that will download the file with a specific name. The issue is that the filename is dynamic, for example today the file name would be
sample_20170419.txt and tomorrow that will change to sample_20170420.txt.
how do we achieve this using SSIS? Any help will be appreciated.