SQL Server Integration Services

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 longstanding 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 also available 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 Integration Services

Licensing: SQL Server

Near-Term Updates and Roadmap (2026–2027)

SQL Server 2025 offered little in the advancement of Integration Services. There was one notable addition, a connection-manager improvement, against a long list of removals and deprecations. Microsoft’s new ETL investment is going to Fabric Data Factory, which gained a preview activity in Mar. 2026 that runs SSIS packages.

Updates

The ADO.NET connection manager gained support for the Microsoft SqlClient Data Provider, the 2025 release’s only functional addition to SSIS.

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

Not a member but want to see the full content? Contact us.