Script JSON Transformation

Overview

Data flow transformation to retrieve data from column containing array with JSON objects.


Setup

The script has the following parameters:

Script Dynamics CRM Entity Source

Overview

Data flow source to retrieve Dynamics CRM entity metadata.


Setup

The script has the following parameter:


Script Checksum Transformation

Overview

Transformation data flow component, which calculates CRC32 checksum for one or more input columns.


Setup

The script has the following parameter:

  • InputColumns - input columns for checksum.

Script Geocode Transformation

Overview

Data flow transformation which loads from Google Geocoding service the latitude and longitude coordinates for data flow input address. The script can cache already loaded coordinates locally for future use. Please keep in mind Google Terms of Service License Restrictions.


Setup

The script has the following parameters:

Script Dynamics CRM Lookup Transformation

Overview

Data flow transformation, performing lookup against Dynamics CRM service.


Setup

The script has the following parameters:

Script ADO.NET Command Transformation

Overview

Data flow transformation, executing SQL command for each row in a data set. It is similar to the standard OLE DB Command transformation, however the executed SQL command is for the ADO.NET connection manager.


Setup

The script has the following parameters:

Script Salesforce Lookup Transformation

Overview

Data flow transformation, performing lookup against Salesforce service.


Setup

The script has the following parameters:

Script Error Description Transformation

Overview

Data flow transformation to extract columns error information.


Introduction

Most of the SSIS data flow components have an error output that allows you to redirect rows that caused errors to a error logging destination. The quality of the information provided by the error output is rather limited. You get: the id of the column that's causing the error, the id of the error and all the input columns of the component. So what’s wrong with that?

Script Counter Transformation

Overview

Transformation data flow component inserting row counter in data flow.


Summary

One of the uses is generation of surrogate keys. It has the following parameters:

  • CounterStart - counter start value.
  • CounterOutputColumn - counter output column name.

Script Conversion Transformation

Overview

Data flow transformation performing column type conversion.


Setup

The script is intentionally asynchronous because it does setup output columns with the same names as the input columns but different type. The script has the following parameters:

Pages