SSIS:Personator World:Address
← SSIS:Data Quality Components
| SSIS Personator World Navigation | ||||||||
|---|---|---|---|---|---|---|---|---|
| Overview | ||||||||
| Tutorial | ||||||||
| ||||||||
| ||||||||
|
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