1183
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
What’s New in SQL Server 2012
Flexible order of authoring and the Resolve References Window. SSIS in SQL Server 2012 is now more
forgiving in situations where remapping the columns in a data fl ow is required. The new Flexible Order
of Authoring enables confi guring of data fl ow components even without metadata, and the Resolve
References Editor, as shown in Figure 52-11, enables quick remapping of columns in the Data Flow.FIGURE 52-11
The Resolve References editor.Using Parameters and Variables
Parameters and variables are confi gured in the Parameters and Variables window. For
packages, this can be reached by clicking on the Parameters tab in the middle of the SSIS
Designer.For Project level parameters, click on the Project.params button directly below your project
in the Solution Explorer window (see Figure 52-12).Creating and Using Parameters to Set Values
Parameters and the Project Deployment Model represent the single biggest change to SSIS
in SQL Server 2012. Parameters behave like read-only variables, they are the replacements
for Confi gurations, and they are used to assign values to properties inside packages.c52.indd 1183c52.indd 1183 7/31/2012 10:29:30 AM7/31/2012 10:29:30 AM
http://www.it-ebooks.info