Integration Services features supported by the editions of SQL Server
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
This topic provides details about the features of SQL Server Integration Services (SSIS) supported by the different editions of SQL Server.
For features supported by Evaluation and Developer editions, see features listed for Enterprise Edition in the following tables.
For the latest release notes and what's new information, see the following articles:
- SQL Server 2016 release notes
- What's New in Integration Services in SQL Server 2016
- What's New in Integration Services in SQL Server 2017
Try SQL Server 2016!
The SQL Server Evaluation edition is available for a 180-day trial period.
Download SQL Server 2016 from the Evaluation Center
New Integration Services features in SQL Server 2017
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| Scale Out Master | Yes | ||||
| Scale Out Worker | Yes | Yes 1 | TBD | TBD | TBD |
| Support for Microsoft Dynamics AX and Microsoft Dynamics CRM in OData components 2 | Yes | Yes | |||
| Linux support | Yes | Yes | Yes |
1 If you run packages that require Enterprise-only features in Scale Out, the Scale Out Workers must also run on instances of SQL Server Enterprise.
2 This feature is also supported in SQL Server 2016 with Service Pack 1.
SQL Server Import and Export Wizard
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| SQL Server Import and Export Wizard | Yes | Yes | Yes | Yes1 | Yes1 |
1 DTSWizard.exe is not provided with SQL on Linux. However, dtexec on Linux can be used to execute a package created by DTSWizard on Windows.
Integration Services
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| Built-in data source connectors | Yes | Yes | |||
| Built in tasks and transformations | Yes | Yes | |||
| ODBC source and destination | Yes | Yes | |||
| Azure data source connectors and tasks | Yes | Yes | |||
| Hadoop/HDFS connectors and tasks | Yes | Yes | |||
| Basic data profiling tools | Yes | Yes |
Integration Services - Advanced sources and destinations
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| High-performance Oracle source and destination by Attunity | Yes | ||||
| High-performance Teradata source and destination by Attunity | Yes | ||||
| SAP BW source and destination | Yes | ||||
| Data mining model training destination | Yes | ||||
| Dimension processing destination | Yes | ||||
| Partition processing destination | Yes |
Integration Services - Advanced tasks and transformations
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| Change Data Capture components by Attunity 1 | Yes | ||||
| Data mining query transformation | Yes | ||||
| Fuzzy grouping and fuzzy lookup transformations | Yes | ||||
| Term extraction and term lookup transformations | Yes |
1 The Change Data Capture components by Attunity require Enterprise edition. The Change Data Capture Service and the Change Data Capture Designer, however, do not require Enterprise edition. You can use the Designer and the Service on a computer where SSIS is not installed.