SSIS:Personator World:Address

← SSIS:Data Quality Components

The Address tab allows you to map your address input fields. At least one Address Line and the country is required.

You can also map your output fields.

Input Columns

Company

Address Line 1

Address Line 2

Address Line 3

Address Line 4

Address Line 5

Address Line 6

Address Line 7

Address Line 8

Locality

Administrative Area

Postal Code

Country

If Country field is not specified or is empty, use country

Address Options

Output Script

Country of Origin

Line Separator

Delivery Lines

Output Columns

Organization

Address Line 1

Address Line 2

Address Line 3

Address Line 4

Address Line 5

Address Line 6

Address Line 7

Address Line 8

Country Name

Latitude

Longitude

Dependent Locality

Locality

Administrative Area

Postal Code

Formatted Address

Address Type

Address Key

ISO 3166-1 Country Code

Country Code

Country ISO3

Country Number

Country Subdivision Code

Additional Output Columns

Parsed Dependent Thoroughfare Columns

Thoroughfare

Pre-Direction

Leading Type

Name

Trailing Type

Post-Direction

Parsed Regional Columns

Double-Dependent Locality

Sub-Administrative Area

Sub-National Area

Parsed Postal Facility Columns

Post Box

Parsed Thoroughfare Columns

Premises Type

Thoroughfare

Pre-Direction

Leading Type

Premises Number

Name

Trailing Type

Post-Direction

Parsed Sub-Premises Columns

Building

Sub Premises

Sub-Premises Type

Sub-Premises Number