SSIS:IP Locator:Input/Output

From Melissa Data Wiki
Revision as of 21:30, 28 July 2017 by Admin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

← SSIS:Data Quality Components

IP Locator Navigation
Overview
Tutorial
Advanced Configuration
Community
On-Premise
Melissa Data Cloud
Dedicated Cloud
IP Locator Tabs
Input/Output
Pass-Through Columns
Output Filter
Result Codes
Result Codes



SSIS IP InputOutput.png


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.
Connection Speed
This field returns the connection speed for the submitted IP address.
Connection Type
This field returns the connection type for the submitted IP address.
Proxy Description
This field returns the proxy description for the submitted IP address.
Proxy Type
This field returns the proxy type for the submitted IP address.
UTC
This field returns the UTC for the submitted IP address.
Continent
This field returns the continent for the submitted IP address.