 <p><a href="https://msdn.microsoft.com/en-us/library/ms141821.aspx" rel="nofollow">I would use a lookup transformation</a> No need for staging - no need to write SQL code - it's the way SSIS was meant to be!</p>