0

I have a SSIS package. Package has an Execute Process Task. Execute Process Task has a Executable property set as C:\Program Files (x86)\WinSCP\WinSCP.exe and Argument property set as below:

/console /command "open sftp://UserName:Password@sftpserverpath.com/ -hostkey=""ssh-rsa 1234 1x:2x:3x:4x:5x:6x:12:1x:21:60:81:e6:a2:3e:b3:c6""" "put \\ServeName\Share\Reporting\Weekly\*.txt /Reports/"  /log="\\ServerName\Share\Reporting\Weekly\WinSCPLogs\winscp1.log" /loglevel=2 "exit"

I am running this package from SQL Server Agent Job. When I run the job it uploads the files then continue running for indefinite time. WinSCP log is attached here.

Jay Desai
  • 821
  • 3
  • 15
  • 42
  • You log is not publicly accessible. And you need to include the log directly into your question anyway. – Martin Prikryl Jul 23 '20 at 05:24
  • @MartinPrikryl Please try again. – Jay Desai Jul 23 '20 at 05:30
  • What time did you collect the logs? It looks like you did collect them in the middle of the upload. – Martin Prikryl Jul 23 '20 at 05:34
  • Are you aware that with `/loglevel=2`, the upload will take magnitudes longer? – Martin Prikryl Jul 23 '20 at 05:45
  • @MartinPrikryl It was only 3 files I was trying to upload. And even after uploading 3 files it was keep running so I stopped the job. If you can check the logs at the end it says, . 2020-07-22 20:23:59.124 Copying finished: Transferred: 2,112,574, Elapsed: 0:00:27, CPS: 80,079/s . 2020-07-22 20:23:59.124 Session upkeep . 2020-07-22 20:23:59.124 Looking for network events . 2020-07-22 20:23:59.124 Timeout waiting for network events – Jay Desai Jul 23 '20 at 05:51
  • So what time did you collect the logs? Did you check that the WinSCP process is still running? Or was it killed somehow? – Martin Prikryl Jul 23 '20 at 16:07
  • @MartinPrikryl, I removed log from the command and worked. Thank you. – Jay Desai Jul 23 '20 at 17:09

1 Answers1

0

I removed log from the command and worked.

/console /command "open sftp://UserName:Password@sftpserverpath.com/ -hostkey=""ssh-rsa 1234 1x:2x:3x:4x:5x:6x:12:1x:21:60:81:e6:a2:3e:b3:c6""" "put \\ServeName\Share\Reporting\Weekly\*.txt /Reports/" "exit"
Jay Desai
  • 821
  • 3
  • 15
  • 42