Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
How to Use Lookups in DTS
By Allan Mitchell
Version 7.0/2000
Level Intermediate
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7 | Page 8 | Page 9

Once we've done that we can go and create our lookup itself. Open up the data Pump and move to the fourth tab (Lookups). This will only be available in SQL Server 2000. For those of us using SQL Server 7 move to the last tab and about half way down on the right hand side is a little button marked Lookups.

Figure 1.2 Creating the Lookup

Create Lookup

In SQL Server 2000 you can simply start entering the details. In SQL Server 7 though you need to press Add

Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7 | Page 8 | Page 9