SSIS Components for Certinia

Build 24.0.9062

QueryResultsV2

Gets the results for a query job. The job must have the state JobComplete.

Input

Name Type Description
JobId String Id of the job being retrieved.
Locator String A string that identifies a specific set of query results. Providing a value for this parameter returns only that set of results.
MaxRecords String The maximum number of records to retrieve per set of results for the query.
FileName String The file name to use when local path is specified.
LocalPath String The local path to save the files to. If no path is specified, the file is kept in memory in the FileData output.
Encoding String The encoding of the data that will be output to FileData.

The allowed values are NONE, BASE64.

The default value is BASE64.

Result Set Columns

Name Type Description
Success String The status of the download for a specific file.
Locator String A string that identifies a specific set of query results.
FullPath String The full path (including name) of the downloaded file.
FileData String The file data output, if the LocalPath input is empty.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062