Re: Error while trying to download a file using BIDS and WinSCP
It seems that you have not specified a password.
- martin
Post a reply
Topic review
- fernandrez
Error while trying to download a file using BIDS and WinSCP
When I connect either via Client or via DOS it works like a charm. In BIDS it seems the Task is hanging while prompting for the password, then i get an error saying WinSCP returned a 1.
Here's the script:
Here's the log:
What could be happening in this SFTP transfer?
Andrés
Here's the script:
option batch abort
option confirm off
open sftp://JAM1001@sftp4.intersourcing.com
lcd c:\compliance11
get JamestownEmployees.csv
close
exit
Here's the log:
. 2013-02-06 16:51:50.610 --------------------------------------------------------------------------
. 2013-02-06 16:51:50.610 Looking up host "sftp4.intersourcing.com"
. 2013-02-06 16:51:50.615 Connecting to 208.86.168.210 port 22
. 2013-02-06 16:51:50.815 Server version: SSH-2.0-1.36_sshlib GlobalSCAPE
. 2013-02-06 16:51:50.815 We believe remote version ignores SSH-2 maximum packet size
. 2013-02-06 16:51:50.815 Using SSH protocol version 2
. 2013-02-06 16:51:50.815 We claim version: SSH-2.0-WinSCP_release_5.1.2
. 2013-02-06 16:51:50.820 Doing Diffie-Hellman group exchange
. 2013-02-06 16:51:50.985 Doing Diffie-Hellman key exchange with hash SHA-1
. 2013-02-06 16:51:51.235 Verifying host key dss 0xc06590a4c8e82e6bbb0af731... with fingerprint ssh-dss 2048 46:fd:71:c4:7e:a6:d9:d1:df:8f:68:d7:53:fd:a2:9b
. 2013-02-06 16:51:51.235 Host key matches cached key
. 2013-02-06 16:51:51.235 Host key fingerprint is:
. 2013-02-06 16:51:51.235 ssh-dss 2048 46:fd:71:c4:7e:a6:d9:d1:df:8f:68:d7:53:fd:a2:9b
. 2013-02-06 16:51:51.235 Initialised AES-256 CBC client->server encryption
. 2013-02-06 16:51:51.235 Initialised HMAC-SHA1 client->server MAC algorithm
. 2013-02-06 16:51:51.235 Initialised AES-256 CBC server->client encryption
. 2013-02-06 16:51:51.235 Initialised HMAC-SHA1 server->client MAC algorithm
! 2013-02-06 16:51:51.440 Using username "JAM1001".
. 2013-02-06 16:51:51.465 Prompt (7, SSH password, , &Password: )
. 2013-02-06 16:51:51.465 Disconnected: Unable to authenticate
. 2013-02-06 16:54:54.843 --------------------------------------------------------------------------
What could be happening in this SFTP transfer?
Andrés