How to use SSIS and WinSCP to Download Files with Wildcard Criteria

There was a need to import files from an SFTP server in one of my recent projects. The catch was that that the filename was not fixed…