Integration Services (SSIS) Scale Out Master
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
The Scale Out Master manages the Scale Out system through the SSISDB Catalog and the Scale Out Master service.
The SSISDB Catalog stores all the information for Scale Out Workers, packages, and executions. It provides the interface to enable a Scale Out Worker and execute packages in Scale Out. For more information, see Walkthrough: Set up Integration Services Scale Out and Run Packages in Integration Services.
The Scale Out Master service is a Windows service that is responsible for the communication with Scale Out Workers. It returns the status of package executions on Scale Out Workers over HTTPS and operates on the data in SSISDB.
Scale Out views and stored procedures in SSISDB
Views
Stored procedures
For managing Scale Out Workers:
For running packages in Scale Out:
Configure the Scale Out Master service
You configure the Scale Out Master service by using the <drive>:\Program Files\Microsoft SQL Server\140\DTS\Binn\MasterSettings.config file. You have to restart the service after updating the configuration file.
| Configuration | Description | Default Value |
|---|---|---|
| PortNumber | The network port number used to communicate with a Scale Out Worker. | 8391 |
| SSLCertThumbprint | The thumbprint of the TLS/SSL certificate used to protect the communication with a Scale Out Worker. | The thumbprint of the TLS/SSL certificate specified during the Scale Out Master installation |
| SqlServerName | The name of the SQL Server that contains the SSISDB catalog. For example, ServerName\InstanceName. | The name of the SQL Server that is installed with the Scale Out Master. |
| CleanupCompletedJobsIntervalInMs | The interval for cleaning up completed execution jobs, in milliseconds. | 43200000 |
| DealWithExpiredTasksIntervalInMs | The interval for dealing with expired execution jobs, in milliseconds. | 300000 |
| MasterHeartbeatIntervalInMs | The interval for the Scale Out Master heartbeat, in milliseconds. This property specifies the interval at which Scale Out Master updates its online status in the SSISDB catalog. | 30000 |
| SqlConnectionTimeoutInSecs | The SQL connection timeout in seconds when connecting to SSISDB. | 15 |
View the Scale Out Master service log
The Scale Out Master service log file is located in the <drive>:\Users\[account]\AppData\Local\SSIS\ScaleOut\Master folder.
The [account] parameter refers to the account running the Scale Out Master service. By default, this account is SSISScaleOutMaster140.
Next steps
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for