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.

SharePoint Destination

Overview

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

SugarCRM Source

Overview

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

Pages