CopyFile
Copies a file from a local or cloud storage.
Procedure-Specific Information
The procedure accepts the parameters
- SourcePath: path of the file you request to copy
- DestinationPath: path of the folder where you request to copy the file
- Usage of absolute path : sftp://localhost:22/folder1/file1.csv will copy the file from the source path /folder1/file1.csv .
- Usage of relative path: file1.csv will copy the file from the source path {CONNECTION STRING URI}/file1.csv If connection string has the URI set to: sftp://localhost:22/folder2, it will copy the file from the source path /folder2/file1.csv.
EXEC COPYFILE @SourcePath = 'sftp://localhost:22/folder1/file1.csv' @DestinationPath = 'sftp://localhost:22/folder2/' //absolute path EXEC COPYFILE @SourcePath = 'file1.csv' @DestinationPath = 'folder2' //relative path
Input
Name | Type | Description |
SourcePath | String | The path of the file which will be copied. |
DestinationPath | String | The path of the file where it will be copied. |
Result Set Columns
Name | Type | Description |
Success | Boolean | Determines if the operation was successful or not. |