When Logging is enabled, the OnInformation event now includes messages such as:
[ABM] Buffer resized: TargetRows=8421, TargetSizeKB=87654 (CPU=0.78, MemFree=1.3GB)
Developers can filter these messages in the SSIS logging UI or via the catalog.event_message view.
| Setting | Location | Values | Default |
|---------|----------|--------|---------|
| AdaptiveBufferMode | Data Flow Task → Properties | Auto (recommended), Disabled, Manual | Auto |
| MinBufferSizeKB | Data Flow Task → Properties | 1 024 – 100 000 | 1 024 |
| MaxBufferSizeKB | Data Flow Task → Properties | 1 024 – 500 000 | 100 000 |
| TargetCPUUtilisation | Data Flow Task → Properties | 0.3 – 0.9 (fraction) | 0.75 |
| SamplingPct | Data Flow Task → Properties | 0.1 – 5 % | 1 % |
When AdaptiveBufferMode = Manual, you can also set TargetRowsPerBuffer and TargetBufferSizeKB directly; the engine will still adjust them within the min/max bounds.
Centralized Watermark Store
Reusable SSIS Tasks/Components
Fault Tolerance & Checkpointing
Observability & Auditing
Security & Multi-environment Support
Migration & Backfill Tools
UX & Configuration
| Version | Feature | Impact | |---------|---------|--------| | SQL 2022 CU1 | Adaptive Network Mode – the engine will automatically switch between MARS, Tabular Direct, and BCP based on live latency measurements without any user‑tuned threshold. | Further reduces latency on cross‑region loads. | | SQL 2022 CU3 | Chunk‑Level Compression – each chunk can be compressed on‑the‑fly (Snappy/Deflate) before being sent over the wire, saving up to 40 % bandwidth on gigabit links. | Ideal for cloud‑to‑cloud migrations. | | SQL 2023 | Integrated Data‑Quality Rules Engine – you can now author data‑quality rules in JSON and have them enforced centrally, with a UI in SSDT for rule management. | Eliminates the need for separate validation pipelines. |
Enable Validation Control
Automated Unit Tests
Deploy with the Same Architecture
Version‑Control Sensitive Data
Document All Credentials
Monitoring & Alerting