we will open the MSSQL Server 2000 Enterprise Manager, from which we can
easily access DTS and many other database functions and objects.
Go to the Start
button on the PC, and then navigate to Microsoft SQL Server --> Enterprise Manager, as shown in Illustration 2:
Manager - Console Root appears.
SQL Servers by clicking the "+" sign to its immediate
Server Group by clicking the "+" sign to its immediate
Manager now appears (with differences based upon our individual operating
environments, of course), as shown in Illustration 3:
3: MSSQL Server 2000 Enterprise Manager View (Compressed View)
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).
Expand the Data Transformation Services folder, exposing the Local Packages icon.
Right-click the Local
The context menu
appears, as shown in Illustration 4.
4: Context Menu from the Local Packages Icon
Package from the context menu.
Designer opens with the DTS Package: <New Package> window, as
shown in Illustration 5.
5: DTS Package: <New Package> Window
-> Text File (Source) from the main menu, as shown in
6: Select Connection -> Text File (Source)
Properties dialog appears.
the New Connection radio button is selected.
into the Name box.
Ensure that Text
File (Source) appears in the Data Source selector box.
Click the ellipses
(...) button to the right of the File Name box.
File dialog appears.
Navigate to its
location, and select
the sample Server Access Log (ServAccessLog.txt) file, which we
downloaded in the preparatory steps above.
Select the ServAccessLog.txt
file by highlighting it.
Click Open to
apply the settings, and to close the Select File dialog.
return to the Connection Properties dialog.
Click the Properties
button beneath the File Name box.
File Properties dialog appears.