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

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

• 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.

The procedure is executed as below:

    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.