There are various ways of using global variables in Microsoft SQL Server 2000 DTS Designer tasks. This article, one in a series, looks into their role in exchanging data between packages, using features built into the Execute Package task. It also explains the purpose of DTS Package Workflow.
Read the full story at Database Journal.