Blog Post

SQL Server Integration Services (SSIS) Blog
3 MIN READ

SQL Server 2025 Integration Services Public Preview

Chunhua's avatar
Chunhua
Icon for Microsoft rankMicrosoft
May 20, 2025

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

Announcing SQL Server 2025 (preview): The AI-ready enterprise database from ground to cloud - Microsoft SQL Server Blog

SQL Server 2025 - AI ready enterprise database from ground to cloud | Microsoft Community Hub

What's New in Integration Services in SQL Server 2025 - SQL Server Integration Services (SSIS) | Microsoft Learn

Updated May 20, 2025
Version 1.0
No CommentsBe the first to comment