1161
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
Expression. For example, the Connection String property of a Connection Manager can be
evaluated by an Expression that includes a variable. The value of the variable can be evalu-
ated at run time, thus changing the value of the connection string.FIGURE 52-5
The Control Flow and Data Flow Toolboxes, side-by-side.Expressions
You use expressions throughout Integration Services to make properties dynamic. Almost
anything that can be hardcoded with a value can be populated in an SSIS package using
an expression. The language used to defi ne an expression is called the SSIS Expression
Language and is native to SSIS, resembling a cross between C# and Transact-SQL. The
Expression Builder editor is available in most places where an expression can be entered.Connection Managers
In the bottom center of your screen is the area for Connection Managers, which are the
wrappers for connection strings and properties required to make a connection at run time.c52.indd 1161c52.indd 1161 7/31/2012 10:29:26 AM7/31/2012 10:29:26 AM
http://www.it-ebooks.info