Hi, What will happne in fuzzy lookup transformation if the value is not peresent in refrence column but in source ? example Reference table Source Col1 Col1 Chinna chin Reddy chinn Ravi By applying fuzzylookup on souce chin and chinn will replace with chinna from refrence table what about ravi will it replace with reddy or will this row ignores by ssis? Regards, Chinna

You can find information of the fuzzy lookup transformation here http://msdn.microsoft.com/en-us/library/ms137786.aspx. I will also move your question to the SSIS forum so that you get better assistance with your question.When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA Blog: Mr. Wharty's Ramblings Twitter: @Mr_Wharty MC ID: Microsoft Transcript