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:

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.

Template

Overview

Template Template Component is SSIS Data Flow Component providing ability to setup data flow output text columns, based on other input columns and package variables and a template. The template definition is based on Apache Velocity engine.

Query

Overview

Query The Query Component is an SSIS Data Flow Component providing the ability to retrieve data from a SQL database by defining data flow input columns as query keys. The Query component supports a variety of connection types as a source.