I want to automate the process of getting files from an external FTP site, as doing this manually daily is quite tedious.
The files are created daily, and only a part of the file name remains consistent each day. There are 5 files, that need to be fetched every single day (Monday - Sunday) from an external FTP server.
At this point in time, I have absolutely no idea where to start, except for knowing that my best bet would probably be to create a batch file, and to have it execute the required script.
Could someone please talk me through how I go about creating a script that will do the following:
Get the 5 files from the external server daily
Rename the files on the destination server daily
Move the source files into a "downloaded folder" on the source server
Move the files on destination server to a "imported directory" only at the end of the day, renaming them by adding a time stamp to the file name.
I would really appreciate as much help as possible here, as I don't have a lot of time to get this setup, and I am unfortunately not making much sense of the WinSCP documentation.
I am running a Windows Server