Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. sFTPScript = sFTPScript & "option batch on" & vbCRLF
  2. sFTPScript = sFTPScript & "option confirm off"& vbCrLf
  3. sFTPScript = sFTPScript & "option transfer binary" & vbCrLf
  4. sFTPScript = sFTPScript & "open sftp://" & FtpUser & ":" & FtpPassword & "@" & FtpServerName & vbCrLf
  5. sFTPScript = sFTPScript & "cd " & FTPFolderPath & vbCrLf
  6. sFTPScript = sFTPScript & "get * " & LocalFolderPath & vbCRLF
  7. sFTPScript = sFTPScript & "close" & vbCrLf
  8. sFTPScript = sFTPScript & "exit" & vbCrLf
  9. sFTPTemp = oFTPScriptShell.ExpandEnvironmentStrings("%TEMP%")
  10. sFTPTempFile = sFTPTemp & "" & oFTPScriptFSO.GetTempName
  11. 'Write the input file for the sftp command to a temporary file.
  12. Set oFTPScript = oFTPScriptFSO.CreateTextFile(sFTPTempFile, True)
  13. oFTPScript.WriteLine(sFTPScript)
  14. oFTPScript.Close
  15. Set oFTPScript = Nothing
  16. sCmd = """C:Program Files (x86)WinSCPwinscp.exe"" /console /log=" & LocalFolderPath & "log_winscp_get_files.log /loglevel=1 -script=" & sFTPTempFile
  17. oFTPScriptShell.run sCmd
  18. Wait 10
  19. If Err.Number <> 0 Then
  20. Reporter.ReportEvent micFail, "Error occured while downloading file from FTP location ["& FTPFolderPath&"] to local folder ["&LocalFolderPath&"]"
  21. rc = micFail
  22. Else
  23. 'oFTPScriptFSO.DeleteFile(LocalFolderPath&"log_winscp_get_files.log")
  24. End If
  25.  
  26. ' Get rid of temp file used for input to sftp
  27. 'oFTPScriptFSO.DeleteFile(sFTPTempFile)
  28. success = oFTPScript.RemoveFile(FTPFolderPath)
  29. If (success <> 1) Then
  30. outFile.WriteLine(oFTPScript.LastErrorText)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement