DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Average: 4.8 (4 votes)


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.

Requirements

Depends on COZYROC Script Component Plus for implementing parameters user interface.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.XML
  • CozyRoc.Sforce
  • System.Web.Services

ScriptMain