Script Data Verification Destination

Overview

Data flow destination, used to verify that an upstream component produces a particular output. The expected data is specified in a CSV-like format without the need to use an external file. The first row contains the column names and each row of data is separated with newline.

The script automatically converts input values to string values (null values are converted to "null" string). If any differences are encountered the script fails and displays the details, including the first difference and the entire expected and actual datasets.

Script Dynamics CRM Association Destination

Overview

Data flow destination, creating Dynamics CRM associations between entities.


Setup

The script has the following parameters:

  • CrmConnection - selects COZYROC Dynamics CRM connection.
  • Action - selects component action: Associate or Disassociate.
  • RelationshipName - specifies relationship name.

Script Table Update Destination

Overview

Data flow destination, providing easier to use alternative of the standard OLE DB Command transformation for amending table records.


Setup

The script has the following parameters:

Script Dataset Destination

Overview

Destination data flow component, loading specified input into in-memory ADO.NET DataSet object. You can use this as alternative to the standard Recordset destination.


Setup

The script has the following parameters:

  • DataSetVariable - variable used to store dataset object.
  • TableName - table name in dataset. This is optional.

EDI Destination

Overview

EDI DestinationThe EDI Destination Component is an SSIS Data Flow Component for generating EDI format files. Introduced in November, 2018 1.9, but based on time-tested technology used in EDI Source, since 2008.

MongoDB Destination

Overview

MongoDB DestinationMongoDB Destination Component is an SSIS Data Flow Component for creating, replacing, updating and deleting documents in a MongoDB database that supports multiple inputs via the composite records pattern.

LDAP Destination

Overview

LDAP Destination The LDAP Destination Component is an SSIS Data Flow Component for loading data into an LDAP object. The configuration parameters are provided in the standard data flow destination component dialog.

SAS Data Destination

Overview

SAS Data Destination Premium component The SAS Data Destination Component is an SSIS Data Flow Component for loading data into SAS's sas7bdat file. The configuration parameters are provided in the standard data flow destination component dialog.

Pages