ADO.NET Provider for CSV

Build 22.0.8462

MoveFile

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462