THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

SSIS Snack: SSIS 2005 Lookup Transformations 101

This blog has moved! You can find this content at the following new location:

Published Tuesday, February 16, 2010 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Jonathan Amen said:

Thanks for this bit. The way the outbound success link reads it won't pass records with no match even if 'Ignore Failure' is selected. Thanks for saving me the testing time to figure this out on my own. /Thumbs up!

October 12, 2010 4:05 PM

Mohamed Harris said:

Good post

September 29, 2011 4:52 AM

Kamakshi Suram said:

Its really useful. Merge Join will take Sorted input and performs Left/swapleft(right)/full/inner joins where as Lookup will do left join.

June 15, 2012 5:30 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement