Here is the code showing the session options. I have the TimeSpan option but it is not correct. I'm not clear how to use sessionoptions.timeout and provide a value for the new timeout option. I have tried using ".Timeout = 100" but that doesn't work either. Can you elaborate?
Dim mySessionOptions As New sessionOptions
With mySessionOptions
.Protocol = Protocol_Sftp
.PortNumber = 22
.Timeout = 100
.HostName = "10.101.200.200"
.UserName = "usr"
.Password = "Haduup"
.SshHostKeyFingerprint = "ssh-rsa 2048 17:xx:xx:xx:xx:xx:xx:5e:9d:6d:89:5d:e4:4e:cc:58"
End With
I have a bash script that calls a number of pig scripts. I execute the script but because I have only 3 mapreduce nodes the session times out. I can manually set the option at login and the job runs fine. I need to set this value in my VB script in Excel so that it stops timing out. Is this possible and what would the syntax look like?
Thanks for the help!