Question: what is difference between lookup and fuzzy lookup in ssis?
Answer: Lookup transformations perform lookups by joining data in input columns with columns in a reference dataset. ... In contrast, the Fuzzy Lookup transformation uses fuzzy matching to return one or more close matches in the reference table. Fuzzy lookups are commonly used to standardize addresses and names.