These components sit between the and the Pipeline Buffer Manager .
jane.doe@techuniv.edu
The primary gain stems from . By informing the source component about which partitions are irrelevant, SSIS avoids materializing rows that would later be filtered out. The effect scales with predicate selectivity and partition granularity . Daily partitions on a two‑year horizon provide enough granularity to prune up to 97 % of partitions for a 1‑day load. SSIS-913