Daily upload of file automation using batch script and WinSCP

Question

So I do have a file that I generate weekly from a server using crontab in Linux side and transfer it to my PC. However, I am having a problem when try to send the file that I generate from a different server on Windows side using task scheduler.

Answer 1

Your command-line syntax is wrong.

I'm assuming the \ftpBinverlog_%yyyy%-%mm%-%dd%.txt is the file, you want to download.

• It won't work, if you just specify it on command-line like you did.
• Also neither Windows scheduler, nor command-interpreter, nor WinSCP understand syntax like %yyyy%.
• The path to the remote file does not look good either. *nix systems use forward slashes, not backslashes.

So just keep your /script and /log arguments:

/script=C:\batchrun\Binver\script.tmp /log="C:\BIN VERIFICATION\ftplog"

And make sure the script.tmp looks like:

open sftp://[email protected]
get /ftpBinverlog_%TIMESTAMP#yyyy-mm-dd%.txt C:\target_path\
exit

References:

• Guide to automating file transfer from SFTP server
• %TIMESTAMP syntax.

Answer 2

Develop a batch file which will download/upload the required file using the SCP command check this for more details.

check this for more details about the scp command parameters.

Make sure that you are able to run the batch with a successful result, then configure it within a scheduled task.

I hope this could help.