Good day experts,
I need to automate the downloading of files from an SFTP location. I have the SFTP host name and folder location to poll for new files.
My workflow basically need to be:
Connect to SFTP and browse the specified folder
Download each file to a local folder
For each successful download, delete or move the original file on SFTP
This process will be executed several times per day.
Please assist / recommend the easiest way to implement this. I have basic skills in SSIS and C# but neither offer native support for SFTP operations.