SSIS Components for CSV

Build 25.0.9434

UploadFile

Uploads a file from a local system to a designated destination, such as a cloud-storage service or remote data repository. This procedure supports data publishing, synchronization, and integration workflows.

Procedure-Specific Information

The DestinationPath input accepts paths relative to the URI provided in the connection string.

If URI is set to: gs://test-bucket/folder2 and DestinationPath='file1.txt', the file will be uploaded to /folder2/file1.txt.

The procedure is executed as below:

    EXEC UploadFile LocalPath='C:/temp/test.txt',  DestinationPath='/hello-cdata.txt'
    EXEC UploadFile InputData='eGN2eGN2eGN2eHp6IGRzZmFzZGZkZmc=',  DestinationPath='CData/hello-cdata.txt'

Input

Name Type Description
DestinationPath String Specifies the full directory path where the uploaded file is stored. The path is relative to the directory that is defined in the URI connection property.
LocalPath String Specifies the full path of the local file that is uploaded from the system.
InputData String Provides the Base64-encoded string representation of the file content. This input is used only when both the LocalPath and InputStream inputs are not set.

Result Set Columns

Name Type Description
Success Bool Indicates whether the file upload operation completed successfully. The Success output returns a value of 'true' when the file is uploaded without error and a value of 'false' when a failure occurs, in which case the Details output provides additional information.
Details String Provides detailed information about any execution failure that occurs during the upload operation. The Details output returns a NULL value when the Success output is true.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434