Showing posts with label unmatched. Show all posts
Showing posts with label unmatched. Show all posts

Wednesday, March 21, 2012

Fuzzy Lookup

How is it possible to get the Unmatched records on the error path of lookup so that they may be passed to a fuzzy lookup. I'm trying to duplicate the 1st example on the Data Cleansing Webcast.

All I'm getting is a null on the title out of the lookup component.

TIA,
GUYCheck out method 2: http://www.sqlis.com/default.aspx?311|||Can you post a link to the SSIS data cleansing webcast?

|||Here you go.. http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050512SQLServerDF/manifest.xml
Idea