Template Task

Overview

The Template Task is an SSIS Control Flow task for generation of text documents like XML, EDI, HTML, CSV, etc. The setup is done in two steps:


SCP Task

Overview

The SCP Task is an SSIS Control Flow task for secure copying of files with an SSH server. For more advanced functionality check SFTP Task.


Setup

Use the General page of the SCP Task Editor dialog to configure the options needed to copy files with a remote SSH server.

Address Parse

Overview

The Address Parse Component is an SSIS Data Flow Component for parsing, correcting and standardizing Addresses in the United States. With an optional purchase of the latest USPS reference database containing more than 120 million addresses, you can verify your addresses and avoid costly errors. The following output columns are generated from successfully parsed address:

ODBC Destination

Overview

The ODBC Destination Component is an SSIS Data Flow Component for loading data into an ODBC-compatible database table. The component can use either the standard ODBC insert interface or the optimized bulk-load engine. The component has been successfully tested with the following databases:

Lookup

Overview

The Lookup Plus Component is an SSIS Data Flow Component providing enhanced functionality as compared to the standard SSIS Lookup component. To simplify your data flows, the component allows multiple lookup definitions in the same dialog and definition of values when the input cannot be matched or when it is undefined. In addition the Lookup Plus component supports a variety of connection types as a source, making it quite versatile.

Table Difference

Overview

The Table Difference Component is an SSIS Data Flow Component designed to find differences between two tables and, in particular, to simplify the management of slowly changing dimensions. The main advantage over the Microsoft standard SCD component is the speed and ease of use.

Salesforce Source

Overview

The Salesforce Source Component is an SSIS Data Flow Component for consuming data from the Salesforce Service. The configuration parameters are provided in the standard data flow source component dialog.

Dynamic Data Flow

Overview

This page describes the dynamic capabilities of COZYROC Data Flow Task Plus. Data Flow Task Plus can dynamically modify source, destination and transformation 1.6 components at runtime. A more detailed information for each component is provided below.

Supported data flow components:

Pages