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:
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.
» 
Comment and Contribute
