(VBScript) Multiple Hop SSH to SFTP

Demonstrates how to SFTP through an intermediate SSH server (multiple hop). The scheme looks like this:

Application => ServerSSH1 => ServerSFtp

The ConnectThroughSsh method is added in Chilkat version 9.5.0.55 to accomplish this task.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.Ssh")
set ssh1 = CreateObject("Chilkat.Ssh")

' Hostname may be an IP address or domain name:
hostname = "192.168.1.111"
port = 22

' Connect directly to the 1st SSH server:
success = ssh1.Connect(hostname,port)
If (success <> 1) Then
    outFile.WriteLine(ssh1.LastErrorText)
    WScript.Quit
End If

' Authenticate using login/password:
success = ssh1.AuthenticatePw("myLogin","myPassword")
If (success <> 1) Then
    outFile.WriteLine(ssh1.LastErrorText)
    WScript.Quit
End If

' Connect through the 1st SSH connection to reach a 2nd SSH server (for SFTP)
' Note: Any number of connections may be simultaneously tunneled through a single
' existing SSH connection.
' For versions of Chilkat < 10.0.0, use CreateObject("Chilkat_9_5_0.SFtp")
set sftp = CreateObject("Chilkat.SFtp")

' Connect to some SSH/SFTP server through ssh1.
success = sftp.ConnectThroughSsh(ssh1,"sftp.someremoteserver.com",22)
If (success <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Authenticate with the SFTP server. 
success = sftp.AuthenticatePw("myLogin","myPassword")
If (success <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' After authenticating, the SFTP subsystem must be initialized:
success = sftp.InitializeSftp()
If (success <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

' Upload from the local file to the SSH server.
' Important -- the remote filepath is the 1st argument,
' the local filepath is the 2nd argument;
remoteFilePath = "hamlet.xml"
localFilePath = "c:/temp/hamlet.xml"

success = sftp.UploadFileByName(remoteFilePath,localFilePath)
If (success <> 1) Then
    outFile.WriteLine(sftp.LastErrorText)
    WScript.Quit
End If

outFile.WriteLine("Success.")

' Close the connection with the SFTP server.(This closes the the tunnel through ssh1.)
' The connection with ssh1 is still alive, and may be used for more connections.
sftp.Disconnect 

' ...
' ...
' ...

ssh1.Disconnect 

outFile.Close