SSIS:IP Locator:Input/Output: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISIPLocatorNav
 
|IPLocatorTabsCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''IP Locator Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:IP Locator|Overview]]
|-
|[[SSIS:IP Locator Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:IP Locator:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:IP Locator:Advanced Configuration#Community|Community]]
|-
|[[SSIS:IP Locator:Advanced Configuration#On-Premise|On-Premise]]
|-
|[[SSIS:IP Locator:Advanced Configuration#Melissa Data Cloud|Melissa Data Cloud]]
|-
|[[SSIS:IP Locator:Advanced Configuration#Dedicated Cloud|Dedicated Cloud]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|IP Locator Tabs
|-
|[[SSIS:IP Locator:Input/Output|Input/Output]]
|-
|[[SSIS:IP Locator:Pass-Through|Pass-Through Columns]]
|-
|[[SSIS:IP Locator:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:IP Locator:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}





Revision as of 00:13, 14 November 2015

← 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




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.