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

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.

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.

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