Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
This article describes the features that have been added or updated in SQL Server 2017 (14.x) Integration Services.
Note
SQL Server 2017 also includes the features of SQL Server 2016 and the features added in SQL Server 2016 updates. For info about the new SSIS features in SQL Server 2016, see What's New in Integration Services in SQL Server 2016.
Highlights of this release
Here are the most important new features of Integration Services in SQL Server 2017.
Scale Out. Distribute SSIS package execution more easily across multiple worker computers, and manage executions and workers from a single master computer. For more info, see Integration Services (SSIS) Scale Out.
Integration Services on Linux. Run SSIS packages on Linux computers. For more info, see Extract, transform, and load data on Linux with SSIS.
Connectivity improvements. Connect to the OData feeds of Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online with the updated OData components.
New in Azure Data Factory
With the public preview of Azure Data Factory version 2 in September 2017, you can now do the following things:
- Deploy packages to the SSIS Catalog database (SSISDB) on Azure SQL Database.
- Run packages deployed to Azure on the Azure-SSIS Integration Runtime, a component of Azure Data Factory version 2.
For more info, see Lift and shift SQL Server Integration Services workloads to the cloud.
These new capabilities require SQL Server Data Tools (SSDT) version 17.2 or later, but don't require SQL Server 2017 or SQL Server 2016. When you deploy packages to Azure, the Package Deployment Wizard always upgrades the packages to the latest package format.
New in the Azure Feature Pack
In addition to the connectivity improvements in SQL Server, the Integration Services Feature Pack for Azure has added support for Azure Data Lake Store. For more info, see the blog post New Azure Feature Pack Release Strengthening ADLS Connectivity. Also see Azure Feature Pack for Integration Services (SSIS).
New in SQL Server Data Tools (SSDT)
You can now develop SSIS projects and packages that target SQL Server versions 2012 through 2017 in Visual Studio 2017 or in Visual Studio 2015. For more info, see Install SQL Server Data Tools (SSDT) for Visual Studio.
New in SSIS in SQL Server 2017
Scale out for SSIS
SQL Server Integration Services (SSIS) Scale Out provides high-performance execution of SSIS packages by distributing package executions across multiple computers. After you set up Scale Out, you can run multiple package executions in parallel, in scale-out mode, from SQL Server Management Studio (SSMS).
For more information, see Integration Services (SSIS) Scale Out.
Support for Microsoft Dynamics online resources
The OData Source and OData Connection Manager now support connecting to the OData feeds of Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online.