Global Variables - How to Use Them to Create Dynamic and Data-Driven DTS Packages - Video Series Video Category: Creating Dynamic DTS Packages with Global Variables and Dynamic Properties Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2000 Global Variables are so important to the DTS Developer today and this video series focuses on creating and working with global variables in DTS

Videos in this Series:

Title Skill Length Download Part 1 - What DTS Global Variables Are and the Architecture of Global Variables   200 13 mins. Download Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task   200 8 mins. Download Part 3 - Using Global Variables Inside the Transform Data Task   300 6 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

SQL Server 2000 Service Pack 3 Additions/Changes: New database role and server configuration to allow cross-database ownership chaining You can disable the "sa" account by setting your SQL Server security mode to Windows Authentication Only. You will still have an "sa" account but it will not be able to log in to your SQL Server SQL Server 2000 Service Pack 3 Additions/Changes: Error reporting built into SQL Server