Performing Internet Protocol Resolution
You use the IP resolution task periodically to resolve Internet Protocol (IP) addresses. This ensures that the Data Warehouse contains as meaningful data as possible.
When you start an IP resolution task, a cache of already resolved IP addresses is checked in an attempt to resolve the new IP addresses. If unresolved IP addresses remain after the cache has been checked, then the Domain Name System (DNS) server is checked. IP resolution typically has a 60 to 75 percent success rate. IP addresses are resolved in a batch file, which optimizes the connection with your DNS server.
When you start an IP resolution task, by default only the IP addresses without a domain name will be resolved. If you want to capture any possible domain name changes, however, you can choose to resolve all IP addresses. This option updates even the domain names already in the Data Warehouse.
.gif "Ee798329.note(en-US,CS.10).gif")
Note
- You must use the full lookup option the first time you resolve IP addresses in the Data Warehouse. After you have performed a full lookup, you can perform incremental IP resolution to look up only new IP addresses.
To resolve IP addresses
Expand Microsoft SQL Server, expand SQL Server Group, and then expand the server on which your Data Warehouse is installed.
Right-click Data Transformation Services, and then click New Package.
Alternatively, if you are changing an existing package, right-click Data Transformation Services, click All Tasks, and then select Open Package. Select the package you want to change, and then click Open.
On the Task menu, click IP resolution (Commerce Server).
In the IP Resolution Properties dialog box, do the following:
Use this To do this Description Type a description for this task. Site name Select from the drop-down list the site that contains the data for which you want to perform IP resolution. Incremental lookup Select this option to resolve only IP addresses that have not already been resolved. Full lookup Select this option to resolve all IP addresses. Local domain name Type the local domain name of the Domain Name Server (DNS) that is the primary server used to resolve IP addresses. Number of days to cache results Type the number of days to cache resolved IP addresses. The default is 30 days. If you increase the default, IP resolution occurs more quickly. However, domain name changes may not be caught. Number of seconds to wait before timeout Type the number of seconds to specify how long the DNS server is searched before an IP address is marked as unresolved. The default is 60 seconds. If you increase the default, you will resolve more IP addresses, but IP resolution will take longer. Number of lookup requests to keep in batch Type the number of lookup requests to specify the number of IP addresses that are transferred to your DNS server in a batch. The default is 500; the possible range is between 10 and 99,999 requests. Click OK.
On the Package menu, click Execute.
The Executing Package dialog box appears, showing the progress of your import. When the import process is complete, the Package Execution Results dialog box informs you it completed successfully.
Click OK, and then click Done.
IP resolution is performed. You must run the Report preparation task to organize the imported data into the designated OLAP cubes. For instructions about running the Report preparation task, see Preparing to Create Reports.
Note
- You can add multiple Data Transformation Services (DTS) tasks to a package, add sequencing or workflow information, and then run all the tasks in the package at one time.