The Address Parse is Data Flow SSIS Component for parsing, correcting and standardizing Addresses in the United States.
##The Address Parse Component is an SSIS Data Flow Component for parsing, correcting and standardizing Addresses in the United States.
Parsed address parts: leading, street, number, suite, city, state, zip code.
Optional feature to check address in USPS reference database with more than 120 million addresses.
Intuitive user interface with fine-grained error control.
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 / P.O. Box number
Suite - Suite
City - City
State - US State
Zip - 5 digit Zip code
Barcode 1.4 SR-3 - 12 digit delivery point barcode. A purchase of the USPS Address Reference database is required.
Predirection 1.5 SR-4 - Pre-direction.
Suffix 1.5 SR-4 - Suffix.
Postdirection 1.5 SR-4 - Post-direction.
Support for SQL Server 2005, 2008, 2012, 2014, 2016, 2017
For a full compatibility list and more information about the COZYROC SSIS+ Components, please visit the COZYROC website