Execution Patterns - SQL Server Integration Services Design Patterns - page 42

Figure 2-1 . Executing an SSIS package deployed to the SSIS Catalog
The Execute Package window displays, as shown in Figure 2-2 . It allows you to
override parameter values, ConnectionString properties of connection managers built at
design-time, or any other externalize-able property accessible from a package path (via
the Advanced tab) for this execution instance of the SSIS package stored in the SSIS
Catalog.
Figure 2-2 . Execute Package window
Integration Server Catalog Stored Procedures
Please note the Script button above the Parameters tab in Figure 2-2 . This button al-
lows you to generate Transact-SQL (T-SQL) statements that will execute the SSIS
package. For the Chapter2.dtsx package stored in the SSIS Catalog, the scripts
will appear similar to those in Listing 2-1 .
Listing 2-1 . T-SQL Script Generated from the Execute Package Window