Run a Package on the SSIS Server Using SQL Server Management Studio

  • Article

After you deploy your project to the Integration Services server, you can run the package on the server.

You can use operations reports to view information about packages that have run, or are currently running, on the server. For more information, see Operations Reports for the Integration Services Server.

To run a package on the server using SQL Server Management Studio

  1. Open SQL Server Management Studio and connect to the instance of SQL Server that contains the Integration Services catalog.

  2. In Object Explorer, expand the Integration Services Catalogs node, expand the SSISDB node, and navigate to the package contained in the project you deployed.

  3. Right-click the package name and select Execute.

  4. Configure the package execution by using the settings on the Parameters, Connection Managers, and Advanced tabs in the Execute Package dialog box.

  5. Click OK to run the package.

    -or-

    Use stored procedures to run the package. Click Script to generate the Transact-SQL statement that creates an instance of the execution and starts an instance of the execution. The statement includes a call to the catalog.create_execution, catalog.set_execution_parameter_value, and catalog.start_execution stored procedures. For more information about these stored procedures, see catalog.create_execution (SSISDB Database), catalog.set_execution_parameter_value (SSISDB Database), and catalog.start_execution (SSISDB Database).