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.

Excel Source

Overview

Excel Source The Excel Source Component is an SSIS Data Flow Component for consuming data from Excel worksheets.

Excel Destination

Overview

Excel Destination The Excel Destination Component is an SSIS Data Flow Component for inserting data into Microsoft Excel worksheets.

Pages