Database Reference
In-Depth Information
Figure 17-13 . Interactive package execution through SSMS
The Execute Package UI also has a Script menu which allows you to script out the
creation of a package execution to T-SQL. Listing 17-2 provides an example of creat-
ing a new package execution and overriding a number of settings. This procedure in-
volves a number of steps:
1. Create a new execution instance using [cata-
log].[create_execution ].
2. Override parameter or connection manager values using [cata-
log].[set_execution_parameter_value] .
3. Set property overrides using [cata-
log].[set_execution_property_override_value] .
4. Start the package execution using [cata-
log].[start_execution] .
 
 
Search WWH ::




Custom Search