Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Active Operations Dialog Box

SQL Server 2012

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)

  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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.