Address Parse

Overview

Address Parse Component is SSIS Data Flow Component for parsing, correcting and standardizing United States Addresses. 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:

• Standardized - The postal address in standard format.
• Type - Type of address
• Leading - Information before address.
• Street - Street name
• Number - Street / POBOX number
• Suite - Suite
• City - City
• State - US State
• Zip - 5 digit Zip code

The component dialog contains the following elements:

• General tab - specify parsed address quality, verification in reference database and how to handle non-parseable rows.
• Mapping tab - select column containing the address to process.
• Error Output tab - specify error handling options.

Setup

Use the options below to setup Address Parse component for processing.

Options

Include Low Quality

Specify to permit low quality addresses.

High Quality

Only high quality addresses are permitted.

Check address in reference database.

Specify to check address in reference database. Address, which cannot be uniquely identified is returned as non-parseable. This option is enabled when you purchase the optional USPS reference database.

Specify how to handle non-parseable addresses

Select an option for handling rows with non-parseable addresses.

When you select Redirect rows to no parse output, the rows are redirected to a no parse output and are not handled as errors. The Error option on the Error Output page of the Address Parse Editor dialog box is not available.

When you select any other option in the Specify how to handle non-parseable addresses list box, the rows are handled as errors. The Error option on the Error Output page is available.