Importing a Log File

  • Article

You can import log files that contain data about user and server activity for your site into the Data Warehouse, and you can run reports on the imported data. Before importing log files, you must choose the site from which you want to import the log files. You must also specify which log files you want to import.

After the event data in the Web logs is processed into the Data Warehouse, you can run a Data Transformation Service (DTS) task to load the descriptive data about the campaign items, such as the name of the discount, and then create a report.

In this lab, you will import a log file into the Data Warehouse and run the post-import process, which you will later use to import a Data Transformation Service (DTS) task. Importing a site log requires using Microsoft SQL Server Enterprise Manager.

Ee798440.note(en-US,CS.10).gif Note

  • The system administrator would typically perform the procedures in this lab.

To synchronize the Data Warehouse with your application

  1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.

  2. In the left pane, expand Microsoft SQL Servers>SQL Server Group>(ServerName)>Data Transformation Services, and select Local Packages.

  3. On the Action menu, click New Package.

    The DTS <New Package> window appears.

  4. On the Task menu, click Configuration synchronization (Commerce Server).

To import the Web Log Files

  1. On the Task menu, click Web server log import (Commerce Server).

  2. In the Import Web Server Logs dialog box, in the Site name box, select Retail from the drop-down list. Under Application select the retail, retailBizDesk application.

  3. In the Log file path box, type <drive:>\Winnt\System32\LogFiles\W3svc1, and then click OK.

To import the profile user data

  1. On the Task menu, click User profile data import (Commerce Server).

  2. In the User Import Properties dialog box, in the Site name box, select Retail from the drop-down list, and then click OK.

To populate the OLAP cubes with the import data

  1. On the Task menu, click Report Preparation (Commerce Server).

  2. In the Prepare Reports Properties dialog box, in the Site name box, verify Retail is selected, and then click OK.

To execute the four DTS tasks

  1. Select the Configuration Synchronization icon that appears in the DTS <New Package> window, hold down the [SHIFT] key, and then click the Report Preparation icon.

    All four Commerce Server DTS Task icons are selected.

  2. On the Workflow menu, click On Completion.

  3. On the Package menu, click Execute.

    You will see a progress dialog box indicating that the tasks are running.

  4. When the tasks have executed successfully, the Package Execution Results dialog box appears. Click OK.

  5. Close SQL Server Enterprise Manager without saving the package.

The data is imported into the Data Warehouse.


All rights reserved.