In fact, Microsoft has stated that new ETL/ELT features will appear first in Data Factory, not in SQL Server on-premise. Therefore, the "SSIS6" you are looking for may already be running in your Azure tenant under a different name.
| 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 |
: Version 6 marked a major shift from version 3 (SQL Server 2008), introducing the Project Deployment Model and the SSIS Catalog (SSISDB) , which revolutionized how packages were managed and monitored. Key Features and Capabilities
Users can create complex workflows, including conditional logic, looping, and more.
Current SSIS is batch-oriented (scheduled or triggered). SSIS6 would introduce with built-in support for Kafka, Azure Event Hubs, and Amazon Kinesis. Think of a data flow that runs continuously, windowing data every few seconds, with checkpointing and exactly-once semantics.
In fact, Microsoft has stated that new ETL/ELT features will appear first in Data Factory, not in SQL Server on-premise. Therefore, the "SSIS6" you are looking for may already be running in your Azure tenant under a different name.
| 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 | In fact, Microsoft has stated that new ETL/ELT
: Version 6 marked a major shift from version 3 (SQL Server 2008), introducing the Project Deployment Model and the SSIS Catalog (SSISDB) , which revolutionized how packages were managed and monitored. Key Features and Capabilities Key Features and Capabilities Users can create complex
Users can create complex workflows, including conditional logic, looping, and more. Think of a data flow that runs continuously,
Current SSIS is batch-oriented (scheduled or triggered). SSIS6 would introduce with built-in support for Kafka, Azure Event Hubs, and Amazon Kinesis. Think of a data flow that runs continuously, windowing data every few seconds, with checkpointing and exactly-once semantics.