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 for this is “//”. Here is a list of the ways to get to the root of a directory on a remote server:
- // Standard
- //! Used when some Linux/Unix OS/SFTP Client will not allow
// to work
- /-/ Used when SFTP client software have combined Java coding
- /-/! Used when some Linux/Unix OS/SFTP Client have a combined Java coding
- /// Used when SFTP client software automatically drops a / in process
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 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 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. ...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 ...Error Message: 0xC0029183 at <TASK NAME> from <FOLDER NAME>, File Transfer Task: File represented by "/output" does not exist.
Action: When executing an SSIS package with the File Transfer Task, the following error is encountered. Error Message: 0xC0029183 at <TASK NAME> from <FOLDER NAME>, File Transfer Task: File represented by "/output" does not exist. ...I recently upgraded to a new release of SSIS+ and noticed that the SFTP Task has been deprecated. Will my existing packages that use the SFTP Task still work with the new SSIS+ release?
The File Transfer Task replaced the SFTP Task starting with SSIS+ version 1.7. Packages that already exist and use the SFTP Task will continue to run without modification after you upgrade to SSIS+ version 1.7 or later. When you create new packages, ...