Script Execute Salesforce DML Task

Overview
Configuration
Knowledge Base

Overview

Script task to execute anonymous Salesforce Apex DML code.

You have to install and use SSIS+ 2.2 SR-1 or above.

Setup

The script has the following parameters:

Connection - selects Salesforce connection.
Code - Apex DML code.

Parameterizing via SSIS variables

Code parameter supports variable references. During runtime, all references to SSIS variables are substituted with their corresponding values.

Example: String myString = '@[User::ApexCodeMessage]'; System.debug(myString);. The @[User::ApexCodeMessage] is a variable reference. During runtime, this reference is replaced with the value of a variable called "User::ApexCodeMessage".

Configuration

To use this script, you would need to load it in COZYROC JavaScript Task. 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.