Post a reply

Username

Subject

Message body

Font colour:

Font size:

[quote="midnite8"]I have success in downloading the files from source to destination but when I add in the [m]-delete[/m] switch, I get a [i]permissions error 3[/i].
This script connects to a SFTP folder that is not connected to the domain so I can't add additional permissions to the folder for the user account that is executing the script.
Is there another way I can delete the files once downloaded?
Below is my script and error
[code]@batch@
@echo off

"C:\Program Files (x86)\WinSCP\WinSCP.com" ^
  /log="C:\Temp\WinSCP Logs\WinSCP.log" /ini=nul ^
  /command ^
    "open sftp://user:password@secureftp.domain.com/ -hostkey=""ssh-rsa 2048 key""" ^
    "cd /" ^
    "lcd H:\folder" ^
    "get -delete ""*.*""" ^
    "exit"

set WINSCP_RESULT=%ERRORLEVEL%
if %WINSCP_RESULT% equ 0 (
  echo Success
) else (
  echo Error
)

exit /b %WINSCP_RESULT%
[/code]
[code]@sessionlog@
. 2023-03-30 11:35:21.510 Copying 45 files/directories to local directory "H:\Folder" - total size: 972,451
. 2023-03-30 11:35:21.510   PrTime: Yes; PrRO: No; Rght: rw-r--r--; PrR: No (No); FnCs: N; RIC: 0100; Resume: S (102400); CalcS: No; Mask: 
. 2023-03-30 11:35:21.510   TM: B; ClAr: No; RemEOF: No; RemBOM: No; CPS: 0; NewerOnly: No; EncryptNewFiles: Yes; ExcludeHiddenFiles: No; ExcludeEmptyDirectories: No; InclM: ; ResumeL: 0
. 2023-03-30 11:35:21.510   AscM: *.*html; *.htm; *.txt; *.php; *.php3; *.cgi; *.c; *.cpp; *.h; *.pas; *.bas; *.tex; *.pl; *.js; .htaccess; *.xtml; *.css; *.cfg; *.ini; *.sh; *.xml
. 2023-03-30 11:35:21.510 File: '/File.csv' [2023-03-23T16:25:10.000Z] [6200]
. 2023-03-30 11:35:21.510 Copying "/file.csv" to local directory started.
. 2023-03-30 11:35:21.510 Binary transfer mode selected.
. 2023-03-30 11:35:21.510 Opening remote file.
> 2023-03-30 11:35:21.510 Type: SSH_FXP_OPEN, Size: 48, Number: 2051
< 2023-03-30 11:35:21.511 Type: SSH_FXP_STATUS, Size: 31, Number: 1548
. 2023-03-30 11:35:21.511 Discarding reserved response
< 2023-03-30 11:35:21.511 Type: SSH_FXP_STATUS, Size: 27, Number: 1796
. 2023-03-30 11:35:21.511 Discarding reserved response
< 2023-03-30 11:35:21.525 Type: SSH_FXP_HANDLE, Size: 17, Number: 2051
> 2023-03-30 11:35:21.525 Type: SSH_FXP_FSTAT, Size: 21, Number: 2312
< 2023-03-30 11:35:21.527 Type: SSH_FXP_ATTRS, Size: 18, Number: 2312
. 2023-03-30 11:35:21.528 Confirming overwriting of file.
> 2023-03-30 11:35:21.529 Type: SSH_FXP_READ, Size: 29, Number: 2565
< 2023-03-30 11:35:21.531 Status code: 1
. 2023-03-30 11:35:21.531 3 skipped SSH_FXP_WRITE, SSH_FXP_READ, SSH_FXP_DATA and SSH_FXP_STATUS packets.
> 2023-03-30 11:35:21.531 Type: SSH_FXP_CLOSE, Size: 17, Number: 3076
. 2023-03-30 11:35:21.531 Preserving timestamp [2023-03-23T16:25:10.000Z]
. 2023-03-30 11:35:21.531 Transfer done: '/File.csv' => 'H:\Folder\File.csv' [6200]
. 2023-03-30 11:35:21.531 Deleting file "/File.csv".
> 2023-03-30 11:35:21.531 Type: SSH_FXP_REMOVE, Size: 35, Number: 3341
< 2023-03-30 11:35:21.534 Type: SSH_FXP_STATUS, Size: 37, Number: 3341
< 2023-03-30 11:35:21.534 Status code: 3, Message: 3341, Server: Permission denied., Language: en 
. 2023-03-30 11:35:21.534 Asking user:
. 2023-03-30 11:35:21.534 Error deleting file '/File.csv'. ("Permission denied.
. 2023-03-30 11:35:21.534 Error code: 3
. 2023-03-30 11:35:21.534 Error message from server (en): Permission denied.")
< 2023-03-30 11:35:21.534 Script: Error deleting file '/File.csv'.
< 2023-03-30 11:35:21.534 Script: Permission denied.
< 2023-03-30 11:35:21.534 Error code: 3
< 2023-03-30 11:35:21.534 Error message from server (en): Permission denied.
. 2023-03-30 11:35:21.535 Answer: Abort
. 2023-03-30 11:35:21.535 Script: Failed
. 2023-03-30 11:35:21.535 Script: Exit code: 1
. 2023-03-30 11:35:21.535 Closing connection.
. 2023-03-30 11:35:21.535 Sending special code: 1
. 2023-03-30 11:35:21.545 Main session channel closed
. 2023-03-30 11:35:21.545 All channels closed
[/code][/quote]

Options

Disable BBCode in this post

Notify me when a reply is posted (registered users only)

Add an Attachment

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

Filename

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

File Comment

Options

Private file (available to author and site moderators only)

Topic review

martin

Re: Download and Delete Script Issue

2023-04-03

Well, it looks like you do not have permissions on the server to delete the file in that folder. If you do not, nothing in the script will help you. You need to get the permissions first. Or can you delete the files in WinSCP GUI? Or in any other SFTP client?

On common Linux systems, you need write permission to the folder to be able to delete files in the folder.

midnite8

Download and Delete Script Issue

2023-03-30 19:39

I have success in downloading the files from source to destination but when I add in the -delete switch, I get a permissions error 3.
This script connects to a SFTP folder that is not connected to the domain so I can't add additional permissions to the folder for the user account that is executing the script.
Is there another way I can delete the files once downloaded?
Below is my script and error

@echo off
 
"C:\Program Files (x86)\WinSCP\WinSCP.com" ^
  /log="C:\Temp\WinSCP Logs\WinSCP.log" /ini=nul ^
  /command ^
    "open sftp://user:password@secureftp.domain.com/ -hostkey=""ssh-rsa 2048 key""" ^
    "cd /" ^
    "lcd H:\folder" ^
    "get -delete ""*.*""" ^
    "exit"
 
set WINSCP_RESULT=%ERRORLEVEL%
if %WINSCP_RESULT% equ 0 (
  echo Success
) else (
  echo Error
)
 
exit /b %WINSCP_RESULT%

. 2023-03-30 11:35:21.510 Copying 45 files/directories to local directory "H:\Folder" - total size: 972,451
. 2023-03-30 11:35:21.510   PrTime: Yes; PrRO: No; Rght: rw-r--r--; PrR: No (No); FnCs: N; RIC: 0100; Resume: S (102400); CalcS: No; Mask: 
. 2023-03-30 11:35:21.510   TM: B; ClAr: No; RemEOF: No; RemBOM: No; CPS: 0; NewerOnly: No; EncryptNewFiles: Yes; ExcludeHiddenFiles: No; ExcludeEmptyDirectories: No; InclM: ; ResumeL: 0
. 2023-03-30 11:35:21.510   AscM: *.*html; *.htm; *.txt; *.php; *.php3; *.cgi; *.c; *.cpp; *.h; *.pas; *.bas; *.tex; *.pl; *.js; .htaccess; *.xtml; *.css; *.cfg; *.ini; *.sh; *.xml
. 2023-03-30 11:35:21.510 File: '/File.csv' [2023-03-23T16:25:10.000Z] [6200]
. 2023-03-30 11:35:21.510 Copying "/file.csv" to local directory started.
. 2023-03-30 11:35:21.510 Binary transfer mode selected.
. 2023-03-30 11:35:21.510 Opening remote file.
> 2023-03-30 11:35:21.510 Type: SSH_FXP_OPEN, Size: 48, Number: 2051
< 2023-03-30 11:35:21.511 Type: SSH_FXP_STATUS, Size: 31, Number: 1548
. 2023-03-30 11:35:21.511 Discarding reserved response
< 2023-03-30 11:35:21.511 Type: SSH_FXP_STATUS, Size: 27, Number: 1796
. 2023-03-30 11:35:21.511 Discarding reserved response
< 2023-03-30 11:35:21.525 Type: SSH_FXP_HANDLE, Size: 17, Number: 2051
> 2023-03-30 11:35:21.525 Type: SSH_FXP_FSTAT, Size: 21, Number: 2312
< 2023-03-30 11:35:21.527 Type: SSH_FXP_ATTRS, Size: 18, Number: 2312
. 2023-03-30 11:35:21.528 Confirming overwriting of file.
> 2023-03-30 11:35:21.529 Type: SSH_FXP_READ, Size: 29, Number: 2565
< 2023-03-30 11:35:21.531 Status code: 1
. 2023-03-30 11:35:21.531 3 skipped SSH_FXP_WRITE, SSH_FXP_READ, SSH_FXP_DATA and SSH_FXP_STATUS packets.
> 2023-03-30 11:35:21.531 Type: SSH_FXP_CLOSE, Size: 17, Number: 3076
. 2023-03-30 11:35:21.531 Preserving timestamp [2023-03-23T16:25:10.000Z]
. 2023-03-30 11:35:21.531 Transfer done: '/File.csv' => 'H:\Folder\File.csv' [6200]
. 2023-03-30 11:35:21.531 Deleting file "/File.csv".
> 2023-03-30 11:35:21.531 Type: SSH_FXP_REMOVE, Size: 35, Number: 3341
< 2023-03-30 11:35:21.534 Type: SSH_FXP_STATUS, Size: 37, Number: 3341
< 2023-03-30 11:35:21.534 Status code: 3, Message: 3341, Server: Permission denied., Language: en 
. 2023-03-30 11:35:21.534 Asking user:
. 2023-03-30 11:35:21.534 Error deleting file '/File.csv'. ("Permission denied.
. 2023-03-30 11:35:21.534 Error code: 3
. 2023-03-30 11:35:21.534 Error message from server (en): Permission denied.")
< 2023-03-30 11:35:21.534 Script: Error deleting file '/File.csv'.
< 2023-03-30 11:35:21.534 Script: Permission denied.
< 2023-03-30 11:35:21.534 Error code: 3
< 2023-03-30 11:35:21.534 Error message from server (en): Permission denied.
. 2023-03-30 11:35:21.535 Answer: Abort
. 2023-03-30 11:35:21.535 Script: Failed
. 2023-03-30 11:35:21.535 Script: Exit code: 1
. 2023-03-30 11:35:21.535 Closing connection.
. 2023-03-30 11:35:21.535 Sending special code: 1
. 2023-03-30 11:35:21.545 Main session channel closed
. 2023-03-30 11:35:21.545 All channels closed

Post a reply

Topic review

Re: Download and Delete Script Issue

Download and Delete Script Issue

Documentation

Support

Associations

Follow Us