I have been using command line instance of WINSCP for approx 12mths now to download from the Paypal SFTP site, then I use SSIS to process the files and move them into an Archive sub folder.
My question is can I set the synchronise to check for the existence of the file in the Archive folder and if its not matched then download to the Parent folder for processing by SSIS?
Im currently using a simple get without using filemask at all and would rather using an intelligent sync if thats possible. We are reprocessing every file available every night that is available on the SFTP site and then removing data that isnt required as part of the ETL which I dont feel is the right way to do it.
I have looked through the documentation and have seen a number of posts suggesting its feasible just not how to actually do it.
Thanks in advance for any guidance.