InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 08:53:57 GMT20http://www.sqlservercentral.com/Forums/Topic1424924-338-1.aspxThose are some pretty basic requirements. What have you tried so far? It sounds like you are simply looking for a tutorial on how to use the Fuzzy Lookup Transformation. Try Googling for "Fuzzy Lookup Transformation tutorial".Thu, 28 Feb 2013 09:52:48 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1424924-338-1.aspxI have a problem where i would need to do a fuzzy lookup on the below columns and get the possible match for each of the column. How do we achieve this in SSIS fuzzy lookup.The input file( DIrty data) contains the following fields :1. Sales Representative ID2. Sales Representative Name3. Dealer Name4. Product Name5. Vendor Name6. StateWe have created a reference look up( Clean data) for each one of the columns listed above. We would need to do a fuzzy look up on the reference look up tables and generate the possible match for all the fields. Please advise on the solution approach.Thu, 28 Feb 2013 00:03:01 GMTmmswamy