Events
Get certified in Microsoft Fabric—for free!
19 Nov, 23 - 10 Dec, 23
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server SSIS Integration Runtime in Azure Data Factory
This section provides guidance for setting up Integration Services Scale Out in a single-computer environment with the default settings.
In the SQL Server installation wizard, on the Feature Selection page, select the following items:
On the Server Configuration page, click Next to accept the default service accounts and startup types.
On the Database Engine Configuration page, select Mixed Mode and select Add Current User.
On the Integration Services Scale Out Configuration - Master Node and Integration Services Scale Out Configuration - Worker Node pages, click Next to accept the default settings for the port and certificates.
Finish the SQL Server installation Wizard.
Download and install SQL Server Management Studio (SSMS).
Open SSMS and connect to the local Sql Server instance. In Object Explorer, right-click Integration Services Catalogs and select Create Catalog.
In the Create Catalog dialog, the option Enable this server as SSIS scale out master is selected by default.
In SSMS, right-click SSISDB and select Manage Scale Out.
The Integration Services Scale Out Manager app opens. For more info, see Scale Out Manager.
To enable a Scale Out Worker, switch to Worker Manager and select the worker you want to enable. The workers are disabled by default. Click Enable Worker to enable the selected worker.
Now you're ready to run SSIS packages in Scale Out. For more info, see Run Packages in Integration Services (SSIS) Scale Out.
Events
Get certified in Microsoft Fabric—for free!
19 Nov, 23 - 10 Dec, 23
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare now