Ssis6 | 2026 Update |

When a project is deployed, the SSIS runtime assigns internal version numbers. These internal mechanisms—often obfuscated from the end user—ensure that packages deployed from different versions of Visual Studio (SSDT) can run on the server.

For instance, an SSIS package created in Visual Studio 2015 might carry specific schema definitions that the engine must interpret. If a user attempts to deploy a package with a schema version higher than what the server supports, deployment fails. This versioning conflict is a primary source of confusion regarding "SSIS" version numbers in production environments.

Q: When will Microsoft release SSIS6?
A: As of 2025, there is no official announcement. Microsoft has not included "SSIS6" in any SQL Server 2022 or vNext roadmap. The brand focus is on Azure Data Factory. When a project is deployed, the SSIS runtime

Q: Is SSIS dead?
A: No. SSIS remains supported through SQL Server 2022 and beyond (10+ years of lifecycle). But new investment is primarily cloud-centric. SSIS will not die, but it will transform.

Q: Can I run SSIS6 on Linux?
A: You can run current SSIS on Linux via SQL Server 2017+. A theoretical SSIS6 would dramatically improve that experience with container-first design. If a user attempts to deploy a package

The session was not without its friction. Several contentious topics took center stage, debates that would define the final shape of the Convention:

Many organizations now run hybrid models. SSIS6 plays a specific role within the Azure ecosystem via the Azure-SSIS Integration Runtime (IR) . A: As of 2025, there is no official announcement

| Feature | SSIS6 (On-Prem) | Azure-SSIS IR (Cloud) | | :--- | :--- | :--- | | Execution cost | SQL Server licensing + hardware | Pay per vCore/hour | | Data sources | Any OLEDB/ODBC on network | Only those reachable via VNet | | Execution speed | Fast (direct hardware) | 15-20% slower (virtualization overhead) | | Best for | Large ETL (TB scale) | Burst workloads, seasonal ETL |

Pro tip: Use Azure-SSIS IR for dev/test and SSIS6 on-prem for production. Mirror the SSISDB catalog using catalog.migrate_project to keep both in sync.