DeleteFile
Delete file from a local or cloud storage.
Procedure-Specific Information
The procedure PATH parameter accepts relative and absolute paths to the file you request to delete
- Usage of absolute path : sftp://localhost:22/folder1/file1.csv will delete the file in the path /folder1/file1.csv .
- Usage of relative path: file1.csv will delete the file in {CONNECTION STRING URI}/file1.csv If connection string has the URI set to: sftp://localhost:22/folder2, it will delete the file in the path /folder2/file1.csv.
EXEC DELETEFILE @PATH = 'sftp://localhost:22/folder1/file1.csv' //absolute path
EXEC DELETEFILE @PATH = 'file1.csv' //relative path
Input
| Name | Type | Description |
| Path | String | Path of the file to delete. |
Result Set Columns
| Name | Type | Description |
| Success | Boolean | Determines if the operation was successful or not. |