How do I use and assign them in an Execute SQl task?

This is the scenario. We sell books in a great many stores around the World. Sometimes we need to update the amount of sales for a given title in a given store for a particular order number. The details will be passed from an application to our DTS package.

We need to add to our package a SQL Server Connection and an ExecuteSQL task.

Figure 1.7 Package Setup.

The next thing we need to do is add some Global Variables to our package. So right click on the whitespace in the designer choose Package properties and then Global Variables. Figure 1.8 shows the details we entered.

Figure 1.8 Global Variables.