Build a Web Site Traffic Analysis Cube: Part I - Page 3

July 21, 2003

First, we will open the MSSQL Server 2000 Enterprise Manager, from which we can easily access DTS and many other database functions and objects.

1.             Go to the Start button on the PC, and then navigate to Microsoft SQL Server --> Enterprise Manager, as shown in Illustration 2:

Click for larger image

Illustration 2: Navigate to MSSQL Server 2000 Enterprise Manager.

2.             Click Enterprise Manager.

The Enterprise Manager - Console Root appears.

3.             Expand Microsoft SQL Servers by clicking the "+" sign to its immediate left.

4.             Expand SQL Server Group by clicking the "+" sign to its immediate left.

Enterprise Manager now appears (with differences based upon our individual operating environments, of course), as shown in Illustration 3:

Illustration 3: MSSQL Server 2000 Enterprise Manager View (Compressed View)

5.             Expand the Server name for the server upon which you will be working (most likely named after the computer on which it resides, or simply "local" - mine is MOTHER, as shown above, and at other places within our lesson).

6.             Expand the Data Transformation Services folder, exposing the Local Packages icon.

7.             Right-click the Local Packages icon.

The context menu appears, as shown in Illustration 4.

Illustration 4: Context Menu from the Local Packages Icon

8.             Click New Package from the context menu.

The DTS Designer opens with the DTS Package: <New Package> window, as shown in Illustration 5.

Illustration 5: DTS Package: <New Package> Window

9.             Click Connection -> Text File (Source) from the main menu, as shown in Illustration 6.

Illustration 6: Select Connection -> Text File (Source)

The Connection Properties dialog appears.

10.         Ensure that the New Connection radio button is selected.

11.         Type ServerAccessLog into the Name box.

12.         Ensure that Text File (Source) appears in the Data Source selector box.

13.         Click the ellipses (...) button to the right of the File Name box.

The Select File dialog appears.

14.         Navigate to its location, and select the sample Server Access Log (ServAccessLog.txt) file, which we downloaded in the preparatory steps above.

15.         Select the ServAccessLog.txt file by highlighting it.

16.         Click Open to apply the settings, and to close the Select File dialog.

We return to the Connection Properties dialog.

17.         Click the Properties button beneath the File Name box.

The Text File Properties dialog appears.