SSIS:IP Locator:Input/Output

← SSIS:Data Quality Components

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.