ETL Process for the IP Resolution DTS Task
The IP Resolution DTS task resolves Internet Protocol (IP) addresses from imported user data. IP resolution converts IP addresses, imported from your log files, into domain names. For example, 198.105.232.4 becomes www.microsoft.com. This helps readers of your reports to understand the data in the reports more easily.
The IP Resolution task only loads data into the HostNameRef table from rows of the IpRef table that are successfully resolved. If the IpAddress, from the IpRef table, was successfully resolved, the domain name is stored in the Hostname column of the HostNameRef table. If the IP address was not successfully resolved, no data for that row in the IpRef table is loaded into the HostNameRef table. The Status column of the IpRef table is set to 1 if the IP address was resolved, and 0 if the IP address was not resolved. The time of the attempted IP resolution is stored in the LastModifiedTime column of the IpRef table.
The following table lists the columns extracted from the source table, the transformation made, and the column to which the data is saved in the Data Warehouse.
| Source columns from the IpRef table in the Data Warehouse | Transformation | Target columns from the HostNameRef table in the Data Warehouse |
|---|---|---|
|
Generated
If possible, the IP address is resolved and the resolved domain name is loaded. If not resolved, no data is loaded to the HostNameRef table. |
|
|
Generated
Set to 1 if resolved; set to 0 if unresolved. |
|
|
Generated
Time of attempted IP resolution. |
|
See Also
Running the IP Resolution DTS Task
Scripting the IP Resolution DTS Task
Workflow for Running DTS Tasks
Copyright © 2005 Microsoft Corporation.
All rights reserved.