22-25 April 2026

Building a range lookup component

Proposed session for SQLBits 2026

TL; DR

Range lookups are tricky to do in SSIS, but his component makes it easy. In depths session on how that works.

Session Details

The SSIS lookup component can only do equal joins easily, reconfiguring for range lookups where one input is mapped to a range of lookup values is possible, but ineffective. This session covers the development of a range lookup component, that can do equal joins plus one range join. It allows easy configurable range lookups that are also performant. It can be seen as an extension to the step-by-step session by the same author, but results in a component that actually is usable in the day-to-day work.

3 things you'll get out of this session

Practical example of Custom SSIS Pipeline Component New Component for Range Lookups