Integration Services features supported by the editions of SQL Server

APPLIES TO: yesSQL Server yesSSIS Integration Runtime in Azure Data Factory yesAzure Synapse Analytics (SQL DW)

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:

Try SQL Server 2016!

The SQL Server Evaluation edition is available for a 180-day trial period.

Download from Evaluation Center 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

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 Yes Yes

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.