Using WinSCP .NET Assembly from WSH-hosted Active Scripting Languages
Advertisement
Installing and Registering for COM
First, you need to install the WinSCP .NET assembly and register it for COM.
Using from WSH
You use WinSCP .NET assembly from WSH as any other COM library.
Though there are some less known techniques that you may need to use, which are described in following sections.
Accessing Enumeration Values
As JScript and VBScript access COM classes via IDispatch
, they do not make use of type library, hence they do not have direct access to constants defined there, like Protocol.Sftp
for instance. To use these, you have to instruct WSH to import the type library into the script namespace.
You can use Windows Script File (WSF) and its <reference>
tag for that. It makes WSH import all enums from the assembly type library into constants in script namespace with name like <type>_<member>
, e.g. Protocol.Sftp
becomes Protocol_Sftp
.
See how <reference object="WinSCP.Session"/>
allows use of Protocol_Sftp
in below JScript script embedded in WSF:
<job> <reference object="WinSCP.Session" /> <script language="JScript"> var sessionOptions = WScript.CreateObject("WinSCP.SessionOptions"); sessionOptions.Protocol = Protocol_Sftp; sessionOptions.HostName = "example.com"; sessionOptions.UserName = "user"; sessionOptions.Password = "mypassword"; sessionOptions.SshHostKeyFingerprint = "ssh-rsa 2048 xxxxxxxxxxx..."; var session = WScript.CreateObject("WinSCP.Session"); session.Open(sessionOptions); session.PutFiles("d:\\toupload\\*", "/home/user/"); </script> </job>
Advertisement
You run the .wsf
file the same way as you run .js
or .vbs
:
cscript upload.wsf
Event Handlers
The Session
class exposes several events.
If you need to make use of these events:
- Use overload of
WScript.CreateObject
with 2 arguments, passing an unique prefix as the second argument (e.g. “session_”); - Define function with name
<prefix><event>
and two arguments (e.g.sender
ande
) for every event you need to handle.
See following JScript snippet:
function session_FileTransferred(sender, e) { WScript.Echo(e.FileName + " => " + e.Destination); } var session = WScript.CreateObject("WinSCP.Session", "session_");
For a full example, see an example for Session.SynchronizeDirectories
.
And equivalent in VBScript:
Sub session_FileTransferred(sender, e) WScript.Echo e.FileName & " => " & e.Destination End Sub Set session = WScript.CreateObject("WinSCP.Session", "session_")
Error Handling in VBScript
VBScript does not support catching exceptions, what is a common way of handling errors in examples for most other languages.
In case you need to use custom error handling, instead of aborting the script on error (the default for WSH), use On Error
statement.
Use On Error Resume Next
to disable default error handling. Then you need to query Err.Number
after every statement to test for errors. You can revert to default error handling (aborting the script) using On Error GoTo 0
.
' Enable custom error handling On Error Resume Next ' Now, with custom error handling enabled, ' script does not abort, when opening session fails session.Open sessionOptions ' Query for errors If Err.Number <> 0 Then WScript.Echo "Error opening session: " & Err.Description WScript.Quit 1 End If ' Restore default error handling On Error GoTo 0 ' Now, with default error handling restored, ' script aborts, if reading remote directory fails Dim directoryInfo Set directoryInfo = session.ListDirectory("/home/user/")
Advertisement
If you do not want to test for errors after every statement, you need to group the staments you want to guard into a subprocedure and enable custom error handling before calling/entering the subprocedure.
This approach is also recommended to ensure that Session.Dispose
is called even in case of error.
Sub ListDirectory(ByRef session) ' Setup session options ... ' Connect session.Open sessionOptions Dim directoryInfo Set directoryInfo = session.ListDirectory("/home/user/") ' Do some stuff with directory listing ... End Sub Dim session Set session = WScript.CreateObject("WinSCP.Session") ' Enable custom error handling On Error Resume Next ' Now, with custom error handling enabled before calling the ListDirectory subprocedure, ' any statement in the subprocedure terminates the subprocedure (but not the whole script) ListDirectory session ' Query for errors If Err.Number <> 0 Then WScript.Echo "Listing directory failed: " & Err.Description ' Disconnect, clean up session.Dispose WScript.Quit 1 End If ' Disconnect, clean up session.Dispose ' Restore default error handling On Error GoTo 0 ' Now with session cleanly closed, safely do anything unrelated to WinSCP session ...
JScript Example
This example is functionally equivalent to overall C# example for WinSCP .NET assembly.
Advertisement
There are also other JScript examples.
<job> <reference object="WinSCP.Session" /> <script language="JScript"> try { // Setup session options var sessionOptions = WScript.CreateObject("WinSCP.SessionOptions"); sessionOptions.Protocol = Protocol_Sftp; sessionOptions.HostName = "example.com"; sessionOptions.UserName = "user"; sessionOptions.Password = "mypassword"; sessionOptions.SshHostKeyFingerprint = "ssh-rsa 2048 xxxxxxxxxxx..."; var session = WScript.CreateObject("WinSCP.Session"); try { // Connect session.Open(sessionOptions); // Upload files var transferOptions = WScript.CreateObject("WinSCP.TransferOptions"); transferOptions.TransferMode = TransferMode_Binary; var transferResult = session.PutFiles("d:\\toupload\\*", "/home/user/", false, transferOptions); // Throw on any error transferResult.Check(); // Print results var enumerator = new Enumerator(transferResult.Transfers); for (; !enumerator.atEnd(); enumerator.moveNext()) { WScript.Echo("Upload of " + enumerator.item().FileName + " succeeded"); } } finally { // Disconnect, clean up session.Dispose(); } } catch (e) { WScript.Echo("Error: " + e.message); WScript.Quit(1); } </script> </job>
Advertisement
VBScript Example
This example is functionally equivalent to overall C# example for WinSCP .NET assembly, except for error handling.
There are also other VBScript examples.
<job> <reference object="WinSCP.Session" /> <script language="VBScript"> Option Explicit ' Setup session options Dim sessionOptions Set sessionOptions = WScript.CreateObject("WinSCP.SessionOptions") With sessionOptions .Protocol = Protocol_Sftp .HostName = "example.com" .UserName = "user" .Password = "mypassword" .SshHostKeyFingerprint = "ssh-rsa 2048 xxxxxxxxxxx..." End With Dim session Set session = WScript.CreateObject("WinSCP.Session") ' Connect session.Open sessionOptions ' Upload files Dim transferOptions Set transferOptions = WScript.CreateObject("WinSCP.TransferOptions") transferOptions.TransferMode = TransferMode_Binary Dim transferResult Set transferResult = session.PutFiles("d:\toupload\*", "/home/user/", False, transferOptions) ' Throw on any error transferResult.Check ' Print results Dim transfer For Each transfer In transferResult.Transfers WScript.Echo "Upload of " & transfer.FileName & " succeeded" Next ' Disconnect, clean up session.Dispose </script> </job>
Advertisement