1185
Chapter 52: Building, Deploying, and Managing ETL Workfl ows in Integration Services
52
aimed at preventing packages from running with default values, like accidentally
running a production package in a test environment.
Parameters have types of values. Their signifi cance is as follows:■ Value: Design time value.■ (^) Override Values: Default value can be overridden at run time. You can fl ag a proj-
ect to fail if this does not occur.
The methods to change the value of a Parameter are as follows:
■ Through the Project Deployment process, a new value can be sent with the deploy-
ment to the server.
■ In an Execution of a package using the Project Deployment model in SSMS.
■ (^) Using new Environments and Environment Variables inside the SSIS Server/Catalog.
■ Through an Execute Package task using the Project reference type.
Variables
SSIS has variables just like most programming languages, and they are used throughout
SSIS to assign values to properties inside packages. Variables and Parameters behave simi-
larly and you confi gure them in much the same manner. The differences are in scope, expo-
sure to change, and properties.type="general."
New System Variable: ServerExecutionID
New with SSIS in SQL Server 2012 is the system variable named ServerExecutionID. This variable will
record the Execution ID of the project as it is being run from inside the SSIS catalog. It enables develop-
ers to synchronize their custom logging with the new logging features available through the catalog.
Variables have two namespaces, System and User. System Variables come predefi ned and
are useful for standard metadata collection. For instance, the System Variable UserName
captures the username at package run time. Variable names include the namespace; thus
all system variables appear with the word System followed by two colons. User variables
are defi ned using the Variables editor. Their name includes the word User; thus, the user-
defi ned Variable Foo appears as User::Foo.
To create a new user variable, click on the variables button in the upper right corner of
the SSIS designer, right beside the toolbox button. You may also select it from SSIS ➪
Variables. Once the variables dialog box opens, click on the Add Variable button in the
upper left corner.
The options for confi guring User Variables are as follows:
c52.indd 1185c52.indd 1185 7/31/2012 10:29:30 AM7/31/2012 10:29:30 AM
http://www.it-ebooks.info