Script Salesforce Bulk Result Transformation

Overview
Configuration
Knowledge Base

Overview

Data flow transformation, which returns Salesforce bulk-load batch information.

Setup

The script has the following parameters:

Connection - selects COZYROC Salesforce connection.
JobIdVariable - selects variable containing bulk job identifier.
BatchIdColumn - selects upstream column containing batch identifier.

Based on the provided information above, the script will return the following information about each record processed in a batch to the output:

ResultId - created or updated record identifier.
Success - true if record processing succeeded.
Created - true if record created. False if record updated.
Error - error information if processing failed.

Configuration

To use this script, you would need to load it in COZYROC JavaScript Component. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.