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

On the transformation tab we need to select all the fields in the left and right hand side columns. We then delete any mappings that have been create already by SQL Server. Create a new transformation of the type ActiveX Script. Here is the page I saw when I was building this demonstration package.

Figure 1.5 Active X Script Opening

AX Initial

Although you can see the designer has mapped the first column in the source to the first column in the destination there is nothing for our author's first name or last name. Take a look over in the left hand side of Figure 1.5 and you'll see our lookup we just created.

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