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

¹ 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.

² 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

¹ 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

¹ 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.