O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Expressions

As you’ve probably noticed, SSIS variables and expressions often go hand in hand. Expressions can be used in many different parts of a package, including tasks, containers, precedence constraints, and connection managers. These items support having expressions applied to one of their properties. For example, a File connection manager can use an expression to set its ConnectionString property.

Developers can add expressions on most—but not all—properties of most—but not all—package items. Selecting the Expression property in the Properties window and clicking on the ellipsis button opens up an editor dialog box where the developer can select a property and then build an expression for that property.

Expressions are incredibly powerful, ...

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