SQL Server Integration Services Roadmap – The Deprecations Mount

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server Integration Services (SSIS) is a role in SQL Server, Microsoft’s long-standing on-premises database management and business intelligence (BI) software. SSIS provides features used to extract, transform, and load (ETL) data from various sources into one or more destinations on a routine basis.

SSIS is available in SQL Server and as a deployment option in Azure Data Factory, providing a hybrid solution for customers who need to continually move data between on-premises and the cloud.

Product: SQL Server

Licensing: SQL Server

Near Term (2025–2026)

SSIS has gone beyond stalling on-premises and will see an increase in deprecations leading up to SQL Server 2025’s release in late 2025. The only new feature listed for SSIS in SQL Server 2025 is support for a new SQL client; however, the list of breaking changes and deprecated items is quite long, including:

Several data connections that use the older SQL client are being replaced with ADO.NET options

References

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now