Execute Package Dialog Box

Use the Execute Package dialog box to run a package that is stored on the Integration Services server.

An Integration Services package may contain parameters that values stored in environment variables. Before executing such a package, you must specify which environment will be used to provide the environment variable values. A project may contain multiple environments, but only one environment can be used for binding environment variable values at the time of execution. If no environment variables are used in the package, an environment is not required.

Open the Execute Package dialog box

1. In SQL Server Management Studio, connect to the Integration Services server.

   You’re connecting to the instance of the SQL Server Database Engine that hosts the SSISDB database.

2. In Object Explorer, expand the tree to display the Integration Services Catalogs node.

3. Expand the SSISDB node.

4. Expand the folder that contains the package you want to run.

5. Right-click the package, and then click Execute.

Set the Options on the General page

Select Environment to specify the environment that is applied with the package is run.

Set the Options on the Parameters tab

Use the Parameters tab to modify the parameter values that are used when the package runs.

Set the Options on the Connection Managers tab

Use the Connection Managers tab to set the properties of the package connection manager(s).

Set the Options on the Advanced tab

Use the Advanced tab to manage properties and other package settings.

• Add, Edit, Remove
  Click to add, edit, or remove a property.

• Logging level
  Select the logging level for the package execution. For more information, see catalog.set_execution_parameter_value (SSISDB Database).

• Dump on errors
  Specify whether a dump file is created when errors occur during the package execution. For more information, see Generating Dump Files for Package Execution.

• 32-bit runtime
  Specify that the package will execute on a 32-bit system.

Scripting the Options in the Execute Package Dialog Box

While you are in the Execute Package dialog box, you can also use the Script button on the toolbar to write Transact-SQL code for you. The generated script calls the stored procedures catalog.start_execution (SSISDB Database) with the same options that you have selected in the Execute Package dialog box. The script appears in a new script window in Management Studio.