Post a reply

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

martin

Re: Error while trying to download a file using BIDS and WinSCP

It seems that you have not specified a password.
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:
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