Using WinSCP to upload files using SSIS (Error - No Upload )

Advertisement

Guest
Joined:
Posts:
1
Location:
California

Using WinSCP to upload files using SSIS (Error - No Upload )

Hi,

I am trying to upload files using WINSCP and wrote the following file which will be called in the SSIS

Option batch abort
option confirm off
open sftp://username:xxxxxxxxx@secure.xxx.com
lcd C:\Test\Current_Directory
cd /Home/subFolder1/Subfolder2/In
put -nopreservetime "c:\TestingFile.txt" "/Home/subfolder1/subfolder2/In/*.*"
close
exit


I don't get any errors but at the same time I don't see the file getting uploaded in the SFTP ..

Could anyone help me out with this error.. My log file is as follows:

. 2011-08-26 10:47:21.049 --------------------------------------------------------------------------
. 2011-08-26 10:47:21.050 WinSCP Version 5.0.0 (Build 1431) (OS 6.1.7600)
. 2011-08-26 10:47:21.050 Configuration: HKEY_CURRENT_USER\Software\Martin Prikryl\WinSCP 2\
. 2011-08-26 10:47:21.050 Login time: Friday, August 26, 2011 10:47:21 AM
. 2011-08-26 10:47:21.050 --------------------------------------------------------------------------
. 2011-08-26 10:47:21.050 Session name: Username@secure.xxxx.com (Modified stored session)
. 2011-08-26 10:47:21.050 Host name: secure.xxxx.com (Port: 22)
. 2011-08-26 10:47:21.050 User name: username (Password: Yes, Key file: No)
. 2011-08-26 10:47:21.051 Tunnel: No
. 2011-08-26 10:47:21.051 Transfer Protocol: SFTP
. 2011-08-26 10:47:21.051 Ping type: -, Ping interval: 30 sec; Timeout: 15 sec
. 2011-08-26 10:47:21.051 Proxy: none
. 2011-08-26 10:47:21.051 SSH protocol version: 2; Compression: No
. 2011-08-26 10:47:21.051 Bypass authentication: No
. 2011-08-26 10:47:21.051 Try agent: Yes; Agent forwarding: No; TIS/CryptoCard: No; KI: Yes; GSSAPI: No
. 2011-08-26 10:47:21.051 Ciphers: aes,blowfish,3des,WARN,arcfour,des; Ssh2DES: No
. 2011-08-26 10:47:21.051 SSH Bugs: -,-,-,-,-,-,-,-,-
. 2011-08-26 10:47:21.051 SFTP Bugs: -,-
. 2011-08-26 10:47:21.052 Return code variable: Autodetect; Lookup user groups: Yes
. 2011-08-26 10:47:21.052 Shell: default
. 2011-08-26 10:47:21.052 EOL: 0, UTF: 2
. 2011-08-26 10:47:21.052 Clear aliases: Yes, Unset nat.vars: Yes, Resolve symlinks: Yes
. 2011-08-26 10:47:21.052 LS: ls -la, Ign LS warn: Yes, Scp1 Comp: No
. 2011-08-26 10:47:21.052 Local directory: default, Remote directory: home, Update: No, Cache: Yes
. 2011-08-26 10:47:21.053 Cache directory changes: Yes, Permanent: Yes
. 2011-08-26 10:47:21.053 DST mode: 1
. 2011-08-26 10:47:21.053 --------------------------------------------------------------------------
. 2011-08-26 10:47:21.127 Looking up host "secure.xxxx.com"
. 2011-08-26 10:47:21.130 Connecting to 204.10.44.189 port 22
. 2011-08-26 10:47:21.335 Server version: SSH-2.0-9.99 sshlib: 7.0.0.1
. 2011-08-26 10:47:21.336 We believe remote version has SSH-2 ignore bug
. 2011-08-26 10:47:21.336 Using SSH protocol version 2
. 2011-08-26 10:47:21.336 We claim version: SSH-2.0-WinSCP_release_5.0
. 2011-08-26 10:47:21.436 Doing Diffie-Hellman group exchange
. 2011-08-26 10:47:21.815 Doing Diffie-Hellman key exchange with hash SHA-1
. 2011-08-26 10:47:22.189 Host key fingerprint is:
. 2011-08-26 10:47:22.189 ssh-dss 1024 54:bc:73:0f:aa:b0:fa:37:ef:d1:cd:97:be:d6:e1:55
. 2011-08-26 10:47:22.189 Initialised AES-256 SDCTR client->server encryption
. 2011-08-26 10:47:22.190 Initialised HMAC-SHA1 client->server MAC algorithm
. 2011-08-26 10:47:22.190 Initialised AES-256 SDCTR server->client encryption
. 2011-08-26 10:47:22.190 Initialised HMAC-SHA1 server->client MAC algorithm
! 2011-08-26 10:47:22.488 Using username "username".
. 2011-08-26 10:47:22.592 Prompt (7, SSH password, , &Password: )
. 2011-08-26 10:47:22.592 Using stored password.
. 2011-08-26 10:47:22.599 Sent password
. 2011-08-26 10:47:23.148 Access granted
. 2011-08-26 10:47:23.273 Opened channel for session
. 2011-08-26 10:47:23.563 Started a shell/command
. 2011-08-26 10:47:23.565 --------------------------------------------------------------------------
. 2011-08-26 10:47:23.566 Using SFTP protocol.
. 2011-08-26 10:47:23.566 Doing startup conversation with host.
> 2011-08-26 10:47:23.570 Type: SSH_FXP_INIT, Size: 5, Number: -1
< 2011-08-26 10:47:23.678 Type: SSH_FXP_VERSION, Size: 5, Number: -1
. 2011-08-26 10:47:23.678 SFTP version 3 negotiated.
. 2011-08-26 10:47:23.678 We believe the server has signed timestamps bug
. 2011-08-26 10:47:23.678 We will use UTF-8 strings for status messages only
. 2011-08-26 10:47:23.682 Getting current directory name.
. 2011-08-26 10:47:23.682 Getting real path for '.'
> 2011-08-26 10:47:23.682 Type: SSH_FXP_REALPATH, Size: 10, Number: 272
< 2011-08-26 10:47:23.781 Type: SSH_FXP_NAME, Size: 49, Number: 272
. 2011-08-26 10:47:23.781 Real path is '/Home/xxxxxxx'
. 2011-08-26 10:47:23.782 Startup conversation with host finished.
< 2011-08-26 10:47:23.786 Script: Active session: [2] username@secure.xxxx.com
> 2011-08-26 10:47:23.789 Script: lcd C:\Test\Current_Directory
< 2011-08-26 10:47:23.789 Script: C:\Test\Current_Directory
> 2011-08-26 10:47:23.791 Script: cd /Home/folder1/folder2/In
. 2011-08-26 10:47:23.792 Changing directory to "/Home/folder1/folder2/In".
. 2011-08-26 10:47:23.792 Getting real path for '/Home/folder1/folder2/In'
> 2011-08-26 10:47:23.792 Type: SSH_FXP_REALPATH, Size: 30, Number: 528
< 2011-08-26 10:47:23.892 Type: SSH_FXP_NAME, Size: 63, Number: 528
. 2011-08-26 10:47:23.892 Real path is '/Home/folder1/folder2/In'
. 2011-08-26 10:47:23.892 Trying to open directory "/Home/folder1/folder2/In".
> 2011-08-26 10:47:23.892 Type: SSH_FXP_LSTAT, Size: 30, Number: 775
< 2011-08-26 10:47:23.994 Type: SSH_FXP_ATTRS, Size: 37, Number: 775
. 2011-08-26 10:47:23.994 Getting current dire< 2011-08-26 10:47:51.245 Script: Active session: [1] Username@secure.xxxxx.com
> 2011-08-26 10:47:51.250 Script: exit
. 2011-08-26 10:47:51.250 Closing connection.
. 2011-08-26 10:47:51.250 Sending special code: 12
. 2011-08-26 10:47:51.250 Sent EOF message
/Folder2/In/"
. 2011-08-26 10:47:23.999 PrTime: No; PrRO: No; Rght: rw-r--r--; PrR: No (No); FnCs: N; RIC: 01; Resume: S (102400); CalcS: No; Mask: *.*
. 2011-08-26 10:47:23.999 TM: M; ClAr: No; CPS: 0; ExclM(No):
. 2011-08-26 10:47:23.999 AscM: *.*html; *.htm; *.txt; *.php; *.php3; *.cgi; *.c; *.cpp; *.h; *.pas; *.bas; *.tex; *.pl; *.js; .htaccess; *.xtml; *.css; *.cfg; *.ini; *.sh; *.xml
. 2011-08-26 10:47:24.000 File: "c:\TestingFile.txt"
. 2011-08-26 10:47:24.008 Copying "c:\TestingFile.txt" to remote directory started.
. 2011-08-26 10:47:24.008 Ascii transfer mode selected.
. 2011-08-26 10:47:24.008 Opening remote file.
> 2011-08-26 10:47:24.008 Type: SSH_FXP_OPEN, Size: 62, Number: 1027
< 2011-08-26 10:47:24.189 Type: SSH_FXP_HANDLE, Size: 13, Number: 1027
> 2011-08-26 10:47:24.189 Type: SSH_FXP_WRITE, Size: 4112, Number: 1542
. 2011-08-26 10:47:50.575 117 skipped SSH_FXP_WRITE, SSH_FXP_READ, SSH_FXP_DATA and SSH_FXP_STATUS packets.
> 2011-08-26 10:47:50.575 Type: SSH_FXP_CLOSE, Size: 13, Number: 16900
< 2011-08-26 10:47:50.705 Type: SSH_FXP_STATUS, Size: 26, Number: 16390
< 2011-08-26 10:47:51.224 Type: SSH_FXP_STATUS, Size: 26, Number: 16646
< 2011-08-26 10:47:51.224 Type: SSH_FXP_STATUS, Size: 26, Number: 16900
< 2011-08-26 10:47:51.224 Status code: 0
> 2011-08-26 10:47:51.236 Script: close
. 2011-08-26 10:47:51.236 Closing connection.
. 2011-08-26 10:47:51.236 Sending special code: 12
. 2011-08-26 10:47:51.237 Sent EOF message


Thanks in advance for the help.

Regards,
Tr

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
41,517
Location:
Prague, Czechia

Re: Using WinSCP to upload files using SSIS (Error - No Upload )

There's missing part in the log:
. 2011-08-26 10:47:23.994 Getting current dire< 2011-08-26 10:47:51.245 Script: Active session: [1]
Can you try to post it again? Or is the log indeed missing the piece?

Reply with quote

Advertisement

You can post new topics in this forum