| Component | Description | New in 9.4.8 | |-----------|-------------|--------------| | | Orchestrates tasks, containers, and event handlers. | Supports Project‑Level Parameters (global to all packages in a project). | | Data‑Flow Engine | Executes high‑throughput data pipelines (sources → transformations → destinations). | Adaptive Parallelism – auto‑tunes the number of threads per component based on runtime metrics. | | Execution Sandbox | Isolates package runtime from host OS. | AppContainer ‑based isolation (similar to Docker) with optional Secure Execution Profile (SEP). | | Connector Library | Over 150 built‑in connectors (SQL, Oracle, SAP, Azure services, REST, etc.). | Added Azure Data Explorer (Kusto) and Snowflake native connectors. | | Metadata Store | Central catalog (SSISDB) for versioning, parameters, and logging. | Integrated with Azure Monitor and Azure Log Analytics. | | Package Deployment Model | Project deployment model (vs. package model) is default. | Supports Hybrid Deployments (on‑prem + Azure). |
When executing a package, consider using the dtexec command-line utility, which can provide detailed execution reports. ssis948 full
Common technical tags associated with the production's specific scenes. | Component | Description | New in 9