Edit

catalog.add_execution_worker (SSISDB Database)

  • Article

Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory

Applies to: SQL Server 2017 (14.x) and later

Adds a Integration Services Scale Out Worker to an instance of execution in Scale Out.

Syntax

catalog.add_execution_worker [ @execution_id = ] execution_id, [ @workeragent_id = ] workeragent_id

Arguments

[ @execution_id = ] execution_id
The unique identifier for the instance of execution. The execution_id is bigint.

[@workeragent_id = ] workeragent_id
The worker agent id of a Scale Out Worker. The workeragent_id is uniqueIdentifier.

Return Code Value

0 (success)

Result Sets

None

Permissions

This stored procedure requires one of the following permissions:

  • READ and MODIFY permissions on the instance of execution

  • Membership to the ssis_admin database role

  • Membership to the sysadmin server role

Errors and Warnings

The following list describes some conditions that may raise an error or warning:

  • The user does not have the appropriate permissions.

  • The execution identifier is not valid.

  • The worker agent id is not valid.

  • The execution is not in Scale Out.

See Also

Execute packages in Scale Out.