Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBScript import mulitple CSV files from SFTP to local drive

Status
Not open for further replies.

skumarlingam

IS-IT--Management
Sep 30, 2016
4
US
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 : //username:passsword@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.
 
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.
 
Hello Guitarzan,

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

Thank you.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top