Ssis-776

| Situation | Typical Pain Point | |-----------|--------------------| | (≥ 10 B rows) split across daily/monthly partitions | Full scans of irrelevant partitions waste I/O and CPU. | | Staging pipelines that filter on a date range (e.g., “last 7 days”) | The engine still reads every partition, then discards rows downstream. | | Changing partition schemes (adding or dropping partitions) | Hard‑coded partition filters in OLE DB Destination / Lookup become stale, leading to missed rows or errors. | | Limited metadata visibility | Developers cannot see which partitions are actually touched during execution. |

private void BuildNode(XmlReader reader, XmlNode parent) { while (reader.Read()) { switch (reader.NodeType) { case XmlNodeType.Element: // allocate a new node XmlNode node = new XmlNode(reader.Name); parent.AddChild(node); if (!reader.IsEmptyElement) { BuildNode(reader, node); SSIS-776

trigger: branches: include: [ main ]