Configuration - SQL Server Integration Services Design Patterns - page 416

@parameter_value=@var
GO
Note For more information, see the set_object_parameter_value stored
procedure entry in Books Online: http://msdn.microsoft.com/en-us/lib-
rary/ff878162(sql.110).aspx .
Package Execution Through the SSIS Catalog
Default values for parameters and connection manager properties can be overridden
when a package is executed. The Execute Package UI in SSMS (shown in Figure
17-13 ) allows you to specify the values to use for that specific execution of the pack-
age. Project and package-level parameters are displayed on the Parameters tab and
shared connection managers and package-level connection managers are shown in the
Connection Managers tab. The Advanced tab allows you to override property values
that were not exposed as parameters. This feature—called Property Overrides—allows
a DBA to make a quick configuration change to a value within a package without hav-
ing to redeploy the entire project. The functionality is similar to using the /Set com-
mand line option with the DTEXEC utility.