Address Verification

Parent Previous Next


Address Verification Transform


The "Address Verification Transform" uses the USPS database to verify United States addresses.


Important Notes

Address Verification Transform is available for SQL versions 2012 and higher.

Address Verification Transform must be run in 32-bit mode.


Source Data



 Firm Name Source Column - (Optional) Maps the column that contains the person or firm's name.

 Address1 Source Column - (Required) Maps the column that contains the first address line.

 Address2 Data Column - (Optional) Maps the column that contains the second address line (e.g. suite or apartment numbers, building name, etc.)

 City Source Column - (Required) Maps the column that contains the city.

 State Source Column - (Required) Maps the column that contains the state.

 Zip Code Source Column - (Required) Maps the column that contains the zip code.

 Unverified Address Behavior - Options for handling unverified addresses

o  Ignore unverified (unverified addresses will be skipped) - Skips the unverified address and continues execution.

o  Redirect unverified to unverified output - Redirects all unverified addresses to a designated unverified output.

o  Fail upon first unverified address found - Fails the component as soon as an unverified address is encountered.


Output Columns



 Address Data Column - Identifies the column

 Column Behavior - Users can choose between the following:

o  Replace Column

o  Add New Column

o  Do Not Output Column

Output Column Name - Users can change the name of the output column