Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.