Automate an sftp file transfer

Posted on 2012-08-20
Medium Priority
Last Modified: 2012-08-21

I am looking to have a vbscript file scan a folder on a sftp server and if there are files in the directory, move those files to a local folder.  I know there is software out there that can do this, but most are very expensive and have more functions than needed.

Thank you.
Question by:cbones
LVL 59

Assisted Solution

by:Bill Prew
Bill Prew earned 1000 total points
ID: 38313171
Wouldn't you just use an FTP client, and try to copy via MGET all files in the folder to be checked, into a local folder?  If there are no files then nothing will be transferred.  Not sure I see the need for a VBS script, something like WinSCP or Putty could do this all by itself.

LVL 16

Accepted Solution

AlexPace earned 1000 total points
ID: 38314630
There is no native SFTP support in VBScript.

When you say "move" do you intend to both download a copy of the file and also delete it from the server?  

If you do need to delete files after downloading them make sure whatever solution you choose is smart enough to NOT delete the source file if the download fails.

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question