O'Reilly logo

Microsoft SQL Server 2005 Integration Services by Kirk Haselden

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required