SFTP - Windows Script to Automate Synchronize Remote to Local Directory using WinSCP 

THANK YOU! i searched for 3 days for such a nice solution!!

Thank you very much for this! I had to lose time and sanity before I found your video... 🙂 Great job.

Thanks a million for this! You've just earned a new sub

Very useful short and to the point video. Thanks

Simply works. Keep the good work It really help in doing ETL

This is amazing! Thanks for sharing the knowledge! works like a charm.

I have followed your video to automate sync with remote to local and vice versa, However is there a method to use that once a file is deleted from local that it synchronizes with the remote folder and deletes that too. Would be really helpful if you could provide a link or method to resolve this issue.

Thanks for the video ! If i need to transfer same files every day, does this method overwrite the old ones ? I basically have to update same files every day since the content of the files changes daily but file names stay the same.

This did exactly what I needed, great video man.

Have you tried to run the script with the Windows Task Scheduler? I have the ability to run the script manually but adding in Win Task Scheduler is not working.

Thank you. This was a 100% help for me!

This is amazing! Thanks brother!

Love your video & resources, worked first go..! thanks!

where this 4 windows come from? What their connection between them?

Hey mate, that helped me a lot, but I want to sync the local and the remote whenever my local folder changes. Can you help me to do that?

Hi Sir, I am facing this issue. [Execute Process Task] Error: In Executing "C:\Users\kishorer\Documents\Visual Studio 2010\Projects\WINSCP\WinSCP.com" "/script=C:\Users\kishorer\Desktop\Archive\SFTPScript.txt" at "", The process exit code was "1" while the expected was "0". What could be the mistake i have done

when adding a new site (SFTP), Winscp logs me into the server without flagging the SSH key. thoughts?

Hi, thanks for your video. Anyway it works, but cant see the files being sent on the console. What I am missing?

can you do this to download files to a raspberry pi from a remote computer on the same wifi?

Have you tried to schedule the script in Windows scheduler? I got error "Destination cannot be found" when running the script in Windows scheduler, but manual run the script is successful.

Thanks very much. I have a question. Can i synchro only new files?

Does anyone know the script to connect to sftp, if sftp connection is key based. I have sftp server that requires username and a private ssh key to connect to it. Not sure whats WinSCP solution to it

Thank you, had to write it a little differently in my case but it still worked

Hi, it shows connection to server timed out. Can you please help?

Muchas gracias por tu video! hace días que intentaba esto. Como dato adicional: para poder visualizar el host key, también se puede ver presionando el botón de la barra de herramientas Sessión - Información de servidor/protocolo - Pestaña Protocolo y en la parte de Huellas de clave de servidor en la parte final (abajo) aparece el host key. (el valor separados con ": " )

Thank YOU mr. CodeCowboy!

after installing winscp I didnot save my host key. How can I find my host key so that I can run the script, because without the host key I keep getting an error when running the script. And the server I'm connecting to and getting files from is an FTP and not SFTP so do I still need a host key?

Please i mived from ftp to sftp so i need s script to move text files from the server to the local drive

This does not work for me. I don't know my sshhostkey as the FTP was set up by vendor. No other changes made to script. ANy thoughts?

if there is destination is storage account container and it wont have any ssh key. what is the process

how do i use to to transfer file from ftp server to remote location in a shared drive

Thanks, this save me a loooooot of time

How to setup in Task Scheduler: To run WinSCP script, use /script= switch, for example: Program/script: "C:\Program Files (x86)\WinSCP\WinSCP.com" Add arguments: /script="D:\test.txt"

I am trying to access the script and used the links provided. It takes to to a page saying that I need access, I requested for access like two days back but I haven't received any response yet. Can you please give me access to the scrip and batch file

Thanks man! Great job!

Hi there How to do the same using the ppk

I'm not finding any key..is it only for paid version?

How can I prevent it do not overwrite the file with same name when I backup? Many Thanks!

Highly educational.

Works great! Thank you!!!

Amazing! Thanks bro!

What if my key has a password? How will the script look?

Much appreciated Dude, Thanks

how can i sync base on the latest one in time

how can i create an acc in winscp? :C

its great! thanks a lot bro

Hello, I am not getting the message to copy the key can you please help me

Thanks this really helped me.

how to do vice versa?

Hi How can i get this script ..i cannot download?

works perfectly for my FTP server after just a couple minor changes

Hi bro, we are unable to download config file and bat. Please accept my request for download that files

Thanks.. been oddly stumped on this for days. Forgot I needed to call the .txt from my .bat file. Smh. I used to do this all the time.

It works like a charm ! But do you know how to use "keepuptodate" ?

save my ass. company just switched to sftp. works great thanks!

Thank you sir!!!!

Very good!!!

how do I download from Remote to Local from specific Date range or for single day like from yesterday or day before? PLEASE HELP

when i try to run this script i'm getting an exception Too many parameters for command 'synchronize'. what is the solution for this. I'm trying to connect to ftps server

Batch Script download is requiring access. FYI.

Can we synchronize only one type file ? like only text files? if yes how to do this ?

Muito obrigado pela ajuda!

thanks very usefull!

MY HERO! 😀

Great video! Thanks a lot. But is there a way to synch only one specific file from the remote without downloading all 6 of them? In your example, let's say 1001.txt...

Did tried all steps mentioned but while running the batch file got an error winscp.com not recognized as an internal or external command.. Can you help please

Error came out like this. What did i do wrong 'winscp.com' is not recognized as an internal or external command, operable program or batch file.

Thanks!

thanks very much

Thanks for the video, but i'm getting "Nothing to synchronize."

I got success. thanks

Hello, I always receiving this error Authenticating with pre-entered password. Access denied. Connection has been unexpectedly closed. Server sent command exit status 0. Authentication log (see session log for details): Using username "myusername". Access denied. Authentication failed. C:\Program Files (x86)\WinSCP>pause Press any key to continue . . . Same username and password working when i login to Winscp. should i need to activate anything option from Cpanel? or anything else. please let me know what i am doing wrong. i am trying since 2 days. Thanks

Can you make a video of sync to local from remote and delete from remote after each successful file transfer?

Your video is helpful.Can you please upload or share any commands or script for uploading and synchronize the file from Local network folder to Remote server external. I have the Username and Password for remote server. If you can send us the script will be much Thankful.

Thank you for your video, this is amazing , I need help... how about the script, if we download from remote SFTP server to local and after downloaded, the file on remote sftp server automatic deleted. Thank you so much

Perfect . Please let me know how I can schedule this activity .

awesome

I have done stuff like this but using pscp (Putty scp)

nice

Thanks a lot. Very helpful. Additionally, you can give the port number by placing - ":"beside the server. Example: username:password@server:portnumber - hostkey="ssh-***"

winscp.com ??

I cannot make it work...🥲