Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
Introduction To Global Variables
By Allan Mitchell
Version 7.0/2000
Level Beginner
Page 1 | Page 2 | Page 3

Where do we find them?

This is the same in both versions of SQL Server so right click on the white space in Designer and you should see towards the bottom an option for Package Properties

Figure 1.1 Where to look for Global Variables

findGV

Let's move on quickly and choose Package Properties. We then see a tabbed dialog box and regardless of whether you are using SQL Server 7 or 2000 the second tab is the one we want. The tab should be labelled Global Variables.

Figure 1.2 Creating Global Variables

CREATEgv

It is here that we start to notice differences in the version 7 interface and the one in 2000.

Page 1 | Page 2 | Page 3