To brighten the path for others following this later (like me), I wanted to spell out more about what this means for a Lookup in SSIS (according to the package...

(I see this is stale, but I was surprised that no one had responded)

That's normal, based on my experience. Joining to a view allows a more efficient breakdown of...