Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jul 21, 2003

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

By William Pearson

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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM