VBScript import mulitple CSV files from SFTP to local drive

[skumarlingam]

Hello VB gurus please help me out I am new VBscript. I saw bunch of scripts on different sites but there is no straight script for me, to use. since I am not expert to modify.

I am trying to import multiple CSV files from SFTP to local drive. here is the script i copied. I don't know how far is it correct when i execute one blink of cmd window comes and go.

# Connect to the host and login using password
open sftp : //usernameasssword@ftp.xx.com
# Change the remote directory
cd /Distr/Agencies/Transp/MS/EDTT
# get all the CSV files in the remote directory and download them to a specific local directory
mget *.* C:\mylocaldrive\EDTT# Close and terminate the session
exit

I have one more request how to frame vbscript , to export multiple CSV files from local drive to SFTP, can anyone please guide me in VBScript.

Thank you in advance.

 

[guitarzan]

What you posted is not vbscript. A google search for vbscript sftp brings up the site below. I would start there. If you are stuck, post your code and what the problem is.

https://www.example-code.com/vbscript/sftp.asp

 

[skumarlingam]

Thanks for your reply.

Yes you are correct I copied from google search and I tried to modify that. but I failed to make it run successfully. I am sorry I dont have my code.

Thank you.

 

[skumarlingam]

Hello Guitarzan,

Is there anyway can we avoid installing third-party software? ("Chilkat_9_5_0.SFtp").

Thank you.

 

[guitarzan]

Hmm i didn't notice that. I don't know if there is a way to do this natively without a third-party control. Doesn't look like it, but others may have some ideas.

Also have a look at this thread:
thread329-1476699

 

[strongm]

Windows does not support SFTP natively, I'm afraid.

 

[skumarlingam]

Thank you Guitarzan and strongm.