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.
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 by Attunity | 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 destination by Attunity | Yes | ||||
| High-performance Teradata 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 |
|---|---|---|---|---|---|
| Persistent (high-performance) lookups | Yes | ||||
| 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.



