Ssis-776 May 2026

| Roadmap Item | ETA | Description | |--------------|-----|-------------| | Cross‑Database DPP | Q4 2026 | Prune partitions across linked servers (e.g., on‑prem + Azure). | | Partition‑Level Statistics | Q2 2027 | Capture row‑count per partition in the SSIS catalog for smarter resource planning. | | GUI Visualizer | Q3 2026 | A new “Partitions” tab in the Data Flow Designer that shows the exact partitions that will be accessed before execution. | | Policy‑Driven Pruning | 2027 | Administrators can enforce a minimum partition size to be read, preventing accidental full scans caused by malformed filters. |

Stay tuned – the SSIS team is gathering feedback on the GitHub issue SSIS‑776 page. If you have a use‑case that isn’t covered yet (e.g., hybrid columnstore + rowstore tables), drop a comment or open a new issue.

Published on April 16, 2026

| Symptom | Frequency | Typical Log Entry | Likely SSIS‑776? | |---------|-----------|-------------------|------------------| | Package fails on the XML Source step after processing ~80 % of rows | Intermittent (once per run) | Error: 0xC0010009 – The XML source is not valid. | ✔ | | Memory usage spikes to > 3 GB (as shown by Performance Monitor) before the crash | Consistent | Process ID 1234 (DtsDebugHost.exe) uses 3,456 MB. | ✔ | | Package runs fine on small XML (< 50 MB) but fails on larger ones | Predictable | No error for 30 MB test file. | ✔ | | Same package works after disabling XSD validation | Often | XML Source: Validation disabled – success. | ✔ (validation triggers the bug) | | Error appears only after a recent cumulative update | Possible | After CU6 the issue appears; CU7 works. | ❓ (could be regression) | | Package works on a different server (different OS/patch level) | Occasionally | Server B (SQL 2019 SP3) succeeds. | ✔ (environment matters) |

If four or more of the above line up, you’re likely staring at SSIS‑776. SSIS-776

If you were to write a report on this issue:

SSIS‑776 addresses these gaps by introducing: | Roadmap Item | ETA | Description |

SSIS‑776 introduces Dynamic Partition Pruning (DPP) to the SSIS data flow engine. The feature automatically discovers and eliminates unnecessary partitions at runtime, cutting ETL run‑times by 30‑70 % for large, partitioned tables—without any code changes. In this post we’ll: