Template Task

Overview

Template Task 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

SCP Task 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.

Address Parse

Overview

Address Parse 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

ODBC Destination 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:

Table Difference

Overview

Table Difference 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

Salesforce Source The Salesforce Source Component is an SSIS Data Flow Component for consuming data from the Salesforce Service.

Pages