Hi All, What will happen in fuzzy lookup transformation., if the value(row) is not exists in reference column(table) but it exists in source table? Example Ref table source table RefName Name Chinna Chin Reddy Chinn Ravi By applying fuzzylookup on source .. chin and chinn will replace with chinna from ref table but what about ravi will it replace with reddy or will this row ignores SSIS? Regards, Chinna

it based on the similarity threshold you configured during the fuzzy lookup transformation task you set up. you can use the conditional split to divert your lower similarity rows to another route for further analysis.

it based on the similarity threshold you configured during the fuzzy lookup transformation task you set up. you can use the conditional split to divert your lower similarity rows to another route for further analysis.

Hello, Check out the article below. It may help you. http://www.sqlteam.com/article/using-fuzzy-lookup-transformations-in-sql-server-integration-services

Hello, Check out the article below. It may help you. http://www.sqlteam.com/article/using-fuzzy-lookup-transformations-in-sql-server-integration-services