Moves file from a local or cloud storage.

Procedure-Specific Information

The procedure accepts the parameters

• SourcePath: path of the file you request to move
• DestinationPath: path of the folder where you request to move the file

Both PATH parameters accepts relative and absolute paths to the file you request to move

• Usage of absolute path : sftp://localhost:22/folder1/file1.csv will move the file from the source path /folder1/file1.csv .
• Usage of relative path: file1.csv will move 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 move the file from the source path /folder2/file1.csv.

The procedure is executed as below:

    EXEC MOVEFILE @SourcePath='sftp://localhost:22/folder1/file1.csv' @DestinationPath='sftp://localhost:22/folder2/' //absolute path
    EXEC MOVEFILE @SourcePath='file1.csv'  @DestinationPath='folder2' //relative path

Input

Name	Type	Description
SourcePath	String	The path of the file which will be moved.
DestinationPath	String	The path of the file where it will be moved.

Result Set Columns

Name	Type	Description
Success	Boolean	Determines if the operation was successful or not.