SSIS:IP Locator:Input/Output: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{SSISIPLocatorNav | |||
|IPLocatorTabsCollapse= | |||
}} | |||
{ | |||
{ | |||
| | |||
Revision as of 00:13, 14 November 2015
← SSIS:Data Quality Components
| IP Locator Navigation | |||||
|---|---|---|---|---|---|
| Overview | |||||
| Tutorial | |||||
| |||||
| |||||
|
Input Column
The Input/Output tab requires data from a single field in order to populate its output fields.
- IP Address
- Select or enter the field IP Address that will contain the IP Address information to be parsed. This field accepts a string value that must contain a full, well-formed IP address. A well formed IP address contains four numbers between 0 and 255, separated by periods. If you do not set a field for IP address, the Component will not parse name information.
Output Columns
Use this column to map the column names that will receive the verified IP address information. You may select existing columns or create new columns by entering the column names in the boxes.
- Domain
- This field returns the domain name associated with the submitted IP address. If the institution that owns the submitted IP address holds a domain name, such as “melissadata.com” or “cox.net,” this function will return that name.
- ISP Name
- This field returns the name of the internet service provider (ISP) to which the submitted IP address is assigned.
- City
- This field returns the name of the city where the institution owning the submitted IP address is located, if available.
- State/Region
- This field returns a string value containing the name of any regional subdivision within the country of origin for the submitted IP address. For IP addresses based in the United States, this function will return the name of the State in which the IP address is located. In other countries, this field may return the name of the city, another regional description or an empty string.
- Zip/Postal Code
- This field returns the ZIP Code associated with the submitted IP address.
- Country
- This field will return a country name if the matching IP address record also contains a city and, in the U.S., a ZIP Code. Records that do not contain these pairs will not return country information.
- Country Abbreviation
- This field will return a country name if the matching IP address record also contains a city and, in the U.S., a ZIP Code. Records that do not contain these pairs will not return country information Records for ISP located within the following U.S. territories will return the territory name and abbreviation for the country, rather than that of the United States.
- Latitude
- This field returns the city latitude for the submitted IP address.
- Longitude
- This field returns the city longitude for the submitted IP address.