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

Going back to our ExecuteSQL task we open it up, assign its connection to be the SQL Server connection and type in the query you see in Figure 1.9.

Figure 1.9 ExecuteSQL Task Query.

ExecSQL Query

You'll notice the use of ?. You'll also notice that the Parameters button has become active now. It seems a shame to waste it so let's press it and see what we get.

Figure 1.10 Map Variables to Parameters

GVtoParam

Here we have mapped the Global Variables to their corresponding Parameters. This will be resolved at runtime. Staying on this page for a second you'll see that the parameters we have resolved are Input Parameters. We can also assign output parameters.

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