How can I move files between folders on the SFTP Remote Server?
Files on a remote SFTP server may be moved by using the
Rename remote files
Action in the File Transfer Task component. You should just include the name of the directory where you want to move the file(s) in the path using the
NewName
parameter.
When the NewName parameter is a folder, the task will perform multiple files move. And in this case, the OldName parameter can be a wildcard.
For example please look at the screenshot below:
In this case, all .csv files whose name starts with "test_" will be moved to a subfolder
files_subfolder.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
How to structure a package using File Transfer Task to Send Files that match my criteria from several local sub-folders
This video demonstrates how to configure a package, using the File Transfer Task, so that it only sends local files to the remote server if they match specified criteria . Several local folders must be scanned to find the files that should be sent.How can I move files on the remote server?
Files on a remote server may be moved by using the Rename remote files Action. Simply include the name of the directory where you want to move the file(s) in the path using the NewName parameter.How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...How to get to the root directory on a remote server
When getting the list of files from a remote server using the “Get remote files list” action with the File Transfer Task, you may need to use a special escape character sequence to get to the root of the remote directory. The typical characters used ...SFTP Task Error: Authentication was partially successful, but server requires additional authentication with: 'password,keyboard-interactive'. (Rebex.Networking)
If you are getting the subject error when using the File Transfer Task or the SFTP Task to transfer files and the transfer works successfully using a different tool, then check if you are using a semicolon (;) in your password. If so, this is what is ...