MoveFile
Moves a file from one directory to another on the remote SFTP server, preserving the file but changing its location.
Moving Files
SFTP allows only a small subset of columns to be used in the EXEC query. These columns can typically be used with only = comparison. The available columns for MoveFile are RemoteFile and DestinationPath.
For example:
EXECUTE MoveFile RemoteFile = '/home/test/CDataTest/SPTest/TestFile.txt', DestinationPath = '/home/test/CDataTest/SPTest2'
Input
| Name | Type | Required | Description |
| RemoteFile | String | True | The full path and name of the file on the FTP/SFTP server that should be moved. |
| DestinationPath | String | True | The target folder path on the FTP/SFTP server where the file will be relocated. |
Result Set Columns
| Name | Type | Description |
| Success | String | Indicates whether the move operation completed successfully (true) or unsuccessfully (false). |