skumarlingam
IS-IT--Management
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.
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.