We are excited to announce that alongside the release of SQL Server 2025, Integration Services has been updated to ensure seamless and efficient data integration processes.
Support for the Microsoft SqlClient Data Provider with the ADO.NET connection manager
One of the standout enhancements is support for the Microsoft SqlClient Data Provider within the ADO.NET connection manager. This addition brings improved connectivity, especially the new Microsoft Entra authentication modes. Learn more about using Microsoft SqlClient Data Provider with ADO.NET connection manager.
Deprecated features in SQL Server 2025 Integration Services
Legacy Integration Services Service
This legacy Integration Services Service available in SQL Server Management Studio is deprecated in SQL Server 2025 (17.x) Preview Integration Services.
Integration Services 32-bit mode
Integration Services 32-bit mode is deprecated in SQL Server 2025 (17.x) Preview Integration Services engine. Tools including SQL Server Management Studio 21 and SQL Server Integration Services Projects 2022 support 64-bit only in current and onward.
SqlClient Data Provider (SDS) connection type
When editing SSIS package in SSIS Visual Studio extension, in Maintenance Tasks (Including Back Up Database Task, Check Database Integrity Task, Execute SQL Server Agent Job Task, Execute T-SQL Statement Task, History Cleanup Task, and Maintenance Cleanup Task) and For Each loop container enumerators (including ADO.NET Schema Rowset Enumerator and Foreach SMO Enumerator), you can explicitly choose “SqlClient Data Provider” when “New” a connection. The “SqlClient Data Provider” for above is deprecated.
Features moved out of SQL Server 2025 Integration Services
The following section describes removed features in SQL Server 2025 (17.x) Preview Integration Services.
Change Data Capture (CDC) components by Attunity and Change Data Capture (CDC) service for Oracle by Attunity
Change Data Capture (CDC) components by Attunity and Change Data Capture (CDC) service for Oracle by Attunity were deprecated and are no longer available from SQL Server 2025 (17.x) Preview Integration Services and onward. Details refer to the announcement.
Microsoft Connector for Oracle
Microsoft Connector for Oracle was deprecated and are no longer available from SQL Server 2025 (17.x) Preview Integration Services and onward. Details refer to the announcement.
Hadoop related components
Hadoop Hive Task, Hadoop Pig Task, and Hadoop File System Task components are moved out of SQL Server 2025 (17.x) Preview Integration Services and onward.
Breaking changes
.NET API Microsoft.SqlServer.Dts.Runtime Namespace
When upgrading to SSIS 2025, if you use .NET API Microsoft.SqlServer.Dts.Runtime Namespace, your projects need to update the references and rebuild when SSIS Package includes Execute SQL Task or SSIS package has certain SSIS tasks that rely on SQL Server Management Objects (SMO). For more information, see ADO.NET connection manager.
We will improve this in later CU, so that you do not need this manual change.
Learn more about What's New in Integration Services in SQL Server 2025
What's Next
Azure Feature Pack for Integration Services (SSIS Azure Feature Pack)
Azure Feature Pack for SSIS 2025 is not available yet but will be released soon.
Microsoft Connector for Teradata (SSIS) for SSIS 2025 is not available yet.
Integration Services features in SQL Server Management Studio (SSMS IS)
SQL Server Management Studio supports connection to Integration Services 2025 is not available yet but will be released soon.
SQL Server Integration Services Projects 2022
SQL Server Integration Services Projects 2022 for SSIS 2025 is not available yet but will be released soon.
Learn More
SQL Server 2025 - AI ready enterprise database from ground to cloud | Microsoft Community Hub
Microsoft