Topic "Synchronise local compare against Archive Folder"

Author Message
RodgerTDodger
[View user's profile]

Joined: 2014-04-08
Posts: 1
Location: Gloucester, UK
Hi, my first post here so please be gentle.

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.

Rodger
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 25034
Location: Prague, Czechia
No you cannot do this.

But you can synchronize remote folder against archive folder and select the new files for processing (like moving them away to "to be processed" folder).

Somewhat similar task is described here:
https://winscp.net/eng/docs/faq_delete_synchronized_files

Alternatively, you can use file mask with time constraint, e.g. to select only files created in the last 24 hours (or since the last sync).
https://winscp.net/eng/docs/file_mask#size_time
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License