problem with sftp transfer of csv file
Hi
I have created a script to use in SSIS to transfer a csv file to a remote server.
I can use the GUI to transfer the file but when I use the script .txt it doesn't transfer.
It seems to be connecting ok but not sending the file.
any help is appreciated
heres the end of the log
Type: SSH_FXP_REALPATH, Size: 10, Number: 16
< 2014-05-15 14:45:44.349 Type: SSH_FXP_NAME, Size: 23, Number: 16
. 2014-05-15 14:45:44.349 Real path is '/'
. 2014-05-15 14:45:44.349 Startup conversation with host finished.
< 2014-05-15 14:45:44.349 Script: Active session: [1] xxxxxx@99.99.99.99
> 2014-05-15 14:45:44.352 Script: cd /download
. 2014-05-15 14:45:44.352 Cached directory change via "/download" to "/download".
. 2014-05-15 14:45:44.352 Getting current directory name.
< 2014-05-15 14:45:44.352 Script: /download
> 2014-05-15 14:45:44.352 Script: option transfer binary
< 2014-05-15 14:45:44.352 Script: transfer binary
> 2014-05-15 14:45:44.354 Script: put "C:\Projects\EEFeeds\FeedsData\KnowHow\ToBeProcessed\*.csv" "/download/*.csv"
. 2014-05-15 14:45:44.354 Copying 1 files/directories to remote directory "/download/"
. 2014-05-15 14:45:44.354 PrTime: Yes; PrRO: No; Rght: rw-r--r--; PrR: No (No); FnCs: N; RIC: 01; Resume: S (102400); CalcS: No; Mask: *.csv
. 2014-05-15 14:45:44.354 TM: B; ClAr: No; CPS: 0; ExclM(No):
. 2014-05-15 14:45:44.354 AscM: *.*html; *.htm; *.txt; *.php; *.php3; *.cgi; *.c; *.cpp; *.h; *.pas; *.bas; *.tex; *.pl; *.js; .htaccess; *.xtml; *.css; *.cfg; *.ini; *.sh; *.xml
. 2014-05-15 14:45:44.354 File: "C:\Projects\EEFeeds\FeedsData\KnowHow\ToBeProcessed\test.csv"
. 2014-05-15 14:45:44.357 Copying "C:\Projects\EEFeeds\FeedsData\KnowHow\ToBeProcessed\test.csv" to remote directory started.
. 2014-05-15 14:45:44.358 Binary transfer mode selected.
. 2014-05-15 14:45:44.358 Opening remote file.
> 2014-05-15 14:45:44.358 Type: SSH_FXP_OPEN, Size: 43, Number: 259
< 2014-05-15 14:45:44.374 Type: SSH_FXP_HANDLE, Size: 13, Number: 259
> 2014-05-15 14:45:44.374 Type: SSH_FXP_WRITE, Size: 31, Number: 774
> 2014-05-15 14:45:44.376 Type: SSH_FXP_CLOSE, Size: 13, Number: 1028
> 2014-05-15 14:45:44.376 Type: SSH_FXP_SETSTAT, Size: 39, Number: 521
< 2014-05-15 14:45:44.389 Type: SSH_FXP_STATUS, Size: 24, Number: 774
< 2014-05-15 14:45:44.404 Type: SSH_FXP_STATUS, Size: 24, Number: 1028
< 2014-05-15 14:45:44.404 Status code: 0
< 2014-05-15 14:45:44.405 Type: SSH_FXP_STATUS, Size: 24, Number: 521
< 2014-05-15 14:45:44.406 Status code: 0
> 2014-05-15 14:45:44.406 Script: Disconnect
. 2014-05-15 14:45:44.406 Script: Failed
. 2014-05-15 14:45:44.406 Closing connection.
. 2014-05-15 14:45:44.407 Sending special code: 12
. 2014-05-15 14:45:44.408 Sent EOF message
I have created a script to use in SSIS to transfer a csv file to a remote server.
I can use the GUI to transfer the file but when I use the script .txt it doesn't transfer.
It seems to be connecting ok but not sending the file.
any help is appreciated
heres the end of the log
Type: SSH_FXP_REALPATH, Size: 10, Number: 16
< 2014-05-15 14:45:44.349 Type: SSH_FXP_NAME, Size: 23, Number: 16
. 2014-05-15 14:45:44.349 Real path is '/'
. 2014-05-15 14:45:44.349 Startup conversation with host finished.
< 2014-05-15 14:45:44.349 Script: Active session: [1] xxxxxx@99.99.99.99
> 2014-05-15 14:45:44.352 Script: cd /download
. 2014-05-15 14:45:44.352 Cached directory change via "/download" to "/download".
. 2014-05-15 14:45:44.352 Getting current directory name.
< 2014-05-15 14:45:44.352 Script: /download
> 2014-05-15 14:45:44.352 Script: option transfer binary
< 2014-05-15 14:45:44.352 Script: transfer binary
> 2014-05-15 14:45:44.354 Script: put "C:\Projects\EEFeeds\FeedsData\KnowHow\ToBeProcessed\*.csv" "/download/*.csv"
. 2014-05-15 14:45:44.354 Copying 1 files/directories to remote directory "/download/"
. 2014-05-15 14:45:44.354 PrTime: Yes; PrRO: No; Rght: rw-r--r--; PrR: No (No); FnCs: N; RIC: 01; Resume: S (102400); CalcS: No; Mask: *.csv
. 2014-05-15 14:45:44.354 TM: B; ClAr: No; CPS: 0; ExclM(No):
. 2014-05-15 14:45:44.354 AscM: *.*html; *.htm; *.txt; *.php; *.php3; *.cgi; *.c; *.cpp; *.h; *.pas; *.bas; *.tex; *.pl; *.js; .htaccess; *.xtml; *.css; *.cfg; *.ini; *.sh; *.xml
. 2014-05-15 14:45:44.354 File: "C:\Projects\EEFeeds\FeedsData\KnowHow\ToBeProcessed\test.csv"
. 2014-05-15 14:45:44.357 Copying "C:\Projects\EEFeeds\FeedsData\KnowHow\ToBeProcessed\test.csv" to remote directory started.
. 2014-05-15 14:45:44.358 Binary transfer mode selected.
. 2014-05-15 14:45:44.358 Opening remote file.
> 2014-05-15 14:45:44.358 Type: SSH_FXP_OPEN, Size: 43, Number: 259
< 2014-05-15 14:45:44.374 Type: SSH_FXP_HANDLE, Size: 13, Number: 259
> 2014-05-15 14:45:44.374 Type: SSH_FXP_WRITE, Size: 31, Number: 774
> 2014-05-15 14:45:44.376 Type: SSH_FXP_CLOSE, Size: 13, Number: 1028
> 2014-05-15 14:45:44.376 Type: SSH_FXP_SETSTAT, Size: 39, Number: 521
< 2014-05-15 14:45:44.389 Type: SSH_FXP_STATUS, Size: 24, Number: 774
< 2014-05-15 14:45:44.404 Type: SSH_FXP_STATUS, Size: 24, Number: 1028
< 2014-05-15 14:45:44.404 Status code: 0
< 2014-05-15 14:45:44.405 Type: SSH_FXP_STATUS, Size: 24, Number: 521
< 2014-05-15 14:45:44.406 Status code: 0
> 2014-05-15 14:45:44.406 Script: Disconnect
. 2014-05-15 14:45:44.406 Script: Failed
. 2014-05-15 14:45:44.406 Closing connection.
. 2014-05-15 14:45:44.407 Sending special code: 12
. 2014-05-15 14:45:44.408 Sent EOF message
