ADO.NET Provider for CSV

Build 22.0.8462

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

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