Execute Package Dialog Box
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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.
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.
In Object Explorer, expand the tree to display the Integration Services Catalogs node.
Expand the SSISDB node.
Expand the folder that contains the package you want to run.
Right-click the package, and then click Execute.
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.