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

Why The Tutorial

Global Variables allow you to make your DTS packages more flexible. Some of their uses include.

1. Storing Values passed around within a package.

2. Accepting values from outside the package to be used inside it.

3. Holding not only single values but multiple values in a recordset.

Although the following screen shots were done in SQL Server 2000 they are equally relevant to version 7 as well. Where there are differences then we'll point them out as we go. Some of what we previously used Global Variables to do in version 7 has been superseded by the Dynamic Properties task in SQL Server 2000 but there are still areas where you can't do without them.

Page 1 | Page 2 | Page 3