| title | Integration Services Features Supported by the Editions of SQL Server |
|---|---|
| description | Integration Services Features Supported by the Editions of SQL Server |
| author | chugugrace |
| ms.author | chugu |
| ms.reviewer | randolphwest |
| ms.date | 11/27/2025 |
| ms.service | sql |
| ms.subservice | integration-services |
| ms.topic | concept-article |
[!INCLUDE sqlserver-ssis]
This article provides details about the features of SQL Server Integration Services (SSIS) supported by the different editions of [!INCLUDE ssNoVersion_md].
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
- What's New in SQL Server 2025 Integration Services
Try SQL Server 2025
The SQL Server Evaluation edition is available for a 180-day trial period.
:::image type="icon" source="../includes/media/download.svg" border="false"::: Download SQL Server 2025 from the Evaluation Center
ADO.NET connection manager now supports Microsoft SqlClient Data Provider. For more information, see ADO.NET connection manager.
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| Scale Out Master | Yes | No | No | No | No |
| Scale Out Worker | Yes | Yes 1 | No | No | No |
| Support for Microsoft Dynamics AX and Microsoft Dynamics CRM in OData components 2 | Yes | Yes | No | No | No |
| Linux support | Yes | Yes | No | No | 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.
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| SQL Server Import and Export Wizard | Yes | Yes | Yes | Yes 1 | Yes 1 |
1 DTSWizard.exe isn't provided with SQL on Linux. However, dtexec on Linux can be used to execute a package created by DTSWizard on Windows.
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| Built-in data source connectors | Yes | Yes | No | No | No |
| Built in tasks and transformations | Yes | Yes | No | No | No |
| ODBC source and destination | Yes | Yes | No | No | No |
| Azure data source connectors and tasks | Yes | Yes | No | No | No |
| Hadoop/HDFS connectors and tasks | Yes | Yes | No | No | No |
| Basic data profiling tools | Yes | Yes | No | No | No |
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| High-performance Oracle source and destination by Attunity | Yes | No | No | No | No |
| High-performance Teradata source and destination by Attunity | Yes | No | No | No | No |
| SAP BW source and destination | Yes | No | No | No | No |
| Data mining model training destination | Yes | No | No | No | No |
| Dimension processing destination | Yes | No | No | No | No |
| Partition processing destination | Yes | No | No | No | No |
| Feature | Enterprise | Standard | Web | Express with Advanced Services | Express |
|---|---|---|---|---|---|
| Change Data Capture components by Attunity 1 | Yes | No | No | No | No |
| Data mining query transformation | Yes | No | No | No | No |
| Fuzzy grouping and fuzzy lookup transformations | Yes | No | No | No | No |
| Term extraction and term lookup transformations | Yes | No | No | No | No |
1 The Change Data Capture components by Attunity require Enterprise edition. The Change Data Capture Service and the Change Data Capture Designer, however, don't require Enterprise edition. You can use the Designer and the Service on a computer where SSIS isn't installed.