Using WINSCP from SSIS fails
Hi,
I'm using WINSCP from SSIS to transfer files to a server. I have created a script that looks like below:
I execute the script from SSIS and the problem is that the script usually runs ok but sometimes it can't connect to the server and leave the message:
2009-12-23 01:14:53.532 Looking up host "MyServer"
A total log dump is shown below
From the SSIS log I just get a The process exit code was "1" while the expected was "0" so it is hard to find the problem. Anyone who has experienced the same problem or has some tips?
I'm using WINSCP from SSIS to transfer files to a server. I have created a script that looks like below:
------------------------------------------------------ option batch on option confirm off open MyServer-hostkey="ssh-rsa 2048 ........" put C:\*.xml /home/ exit ------------------------------------------------------
I execute the script from SSIS and the problem is that the script usually runs ok but sometimes it can't connect to the server and leave the message:
2009-12-23 01:14:53.532 Looking up host "MyServer"
A total log dump is shown below
------------------------------------------------------ . 2009-12-23 01:14:53.530 WinSCP Version 4.2.4 (Build 610) (OS 6.0.6001 Service Pack 1) . 2009-12-23 01:14:53.530 Login time: 23. december 2009 01:14:53 . 2009-12-23 01:14:53.530 -------------------------------------------------------------------------- . 2009-12-23 01:14:53.531 Session name: MyServer . 2009-12-23 01:14:53.531 Host name: MyServer (Port: 22) . 2009-12-23 01:14:53.531 User name: (Password: No, Key file: No) . 2009-12-23 01:14:53.531 Tunnel: No . 2009-12-23 01:14:53.531 Transfer Protocol: SFTP (SCP) . 2009-12-23 01:14:53.531 Ping type: -, Ping interval: 30 sec; Timeout: 15 sec . 2009-12-23 01:14:53.531 Proxy: none . 2009-12-23 01:14:53.531 SSH protocol version: 2; Compression: No . 2009-12-23 01:14:53.531 Bypass authentication: No . 2009-12-23 01:14:53.531 Try agent: Yes; Agent forwarding: No; TIS/CryptoCard: No; KI: Yes; GSSAPI: No . 2009-12-23 01:14:53.531 Ciphers: aes,blowfish,3des,WARN,arcfour,des; Ssh2DES: No . 2009-12-23 01:14:53.531 SSH Bugs: -,-,-,-,-,-,-,-,- . 2009-12-23 01:14:53.531 SFTP Bugs: -,- . 2009-12-23 01:14:53.531 Return code variable: Autodetect; Lookup user groups: Yes . 2009-12-23 01:14:53.531 Shell: default, EOL: 0 . 2009-12-23 01:14:53.531 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes . 2009-12-23 01:14:53.531 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No . 2009-12-23 01:14:53.531 Local directory: default, Remote directory: home, Update: No, Cache: Yes . 2009-12-23 01:14:53.531 Cache directory changes: Yes, Permanent: Yes . 2009-12-23 01:14:53.531 DST mode: 1 . 2009-12-23 01:14:53.531 ----------------------------------------------------------------------- . 2009-12-23 01:14:53.532 Looking up host "MyServer" ------------------------------------------------------
From the SSIS log I just get a The process exit code was "1" while the expected was "0" so it is hard to find the problem. Anyone who has experienced the same problem or has some tips?
