How to retrieve the list of files in an SFTP directory using SSIS ?
I currently have access to an SFTP directory, where new files are uploaded periodically. Old files are not deleted. In my database, I have a list of processed files in a table. Now, when i invoke the process the next time, I need to compare the list of files present in the SFTP directory with the list of file names present in my table, and download only the files from SFTP which have not been processed yet. What is the best way to determine the list of unprocessed files ?