Interestingly enough, the biggest cost to the initial query, which probably exceeded benefits of denormalization, was using a 'function' in a WHERE predicate...
The best one that I can think of in SSIS is the "Lookup" task in the "Data Flow Transformation" section within the "Data Flow Task". It's not as straight...