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.

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

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.