| title | Get Started with SSIS Scale Out on a Single Computer| Microsoft Docs | |||
|---|---|---|---|---|
| description | This article shows you everything you need to know to get started with SSIS Scale Out on a single computer | |||
| author | chugugrace | |||
| ms.author | chugu | |||
| ms.reviewer | ||||
| ms.date | 12/13/2017 | |||
| ms.service | sql | |||
| ms.subservice | integration-services | |||
| ms.topic | get-started | |||
| ms.custom |
|
[!INCLUDEsqlserver-ssis]
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:
- Database Engine Services
- Integration Services
- Scale Out Master
- Scale Out Worker
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.
Install the latest version of 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.