Execute Package Dialog Box


Applies To: SQL Server 2016

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.

What do you want to do?

  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.

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

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

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

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.

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.

Community Additions