Chapter 12. The Venerable Variable

IN THIS CHAPTER

Important Variable Concepts—Properties, Scope, Type, and Namespace

System Variables

Creating and Using Variables

Execution Time Behavior

Variable Tips and Tricks

“IT’S REALLY EASY IF YOU’RE IGNORANT.”—JAMES HOWEY

In each succeeding version of DTS, variables have taken on a more important and central role in packages. This is certainly true of Integration Services (IS). In IS, variables have become absolutely essential. Variables are the primary method of communication between all components and make it possible to create packages that are more dynamic and configurable. This chapter discusses important concepts about variables and how to use them.

A common guideline in any traditional ...

Get Microsoft SQL Server 2005 Integration Services now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.