Building a range lookup component
Proposed session for SQLBits 2026TL; 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
Speakers
Arne Bartels's other proposed sessions for 2026
SSIS ScriptComponents are not that bad - 2026
Step-by-step towards building a SSIS Custom Pipeline Component - 2026