Active Operations Dialog Box

  • Article

Use the Active Operations dialog box to view the status of currently running Integration Services operations on the Integration Services server, such as deployment, validation, and package execution. This data is stored in the SSISDB catalog.

For more information about related Transact-SQL views, see catalog.operations (SSISDB Database), catalog.validations (SSISDB Database), and catalog.executions (SSISDB Database)

What do you want to do?

  1. Open the Active Operations Dialog Box

  2. Configure the Options

Open the Active Operations Dialog Box

  1. Open SQL Server Management Studio.

  2. Connect Microsoft SQL Server Database Engine

  3. In Object Explorer, expand the Integration Services node, right-click SSISDB, and then click Active Operations.

Configure the Options

Options

  • Type
    Specifies the type of operation. The following are the possible values for the Type field and the corresponding values in the operations_type column of the Transact-SQL catalog.operations view.

    Integration Services initialization

    1

    Operations cleanup (SQL Agent job)

    2

    Project versions cleanup (SQL Agent job)

    3

    Deploy project

    101

    Restore project

    106

    Create and start package execution

    200

    Stop operation (stopping a validation or execution

    202

    Validate project

    300

    Validate package

    301

    Configure catalog

    1000

  • Stop
    Click to stop a currently running operation.