How to use Fuzzy Lookup in SSIS

The Fuzzy Lookup transformation performs data cleaning tasks such as standardizing data, correcting data, and providing missing values.

The following example show that how to use it for Lookup for bad data.

The package design:

Flat file source

Lookup Table

Flat File Source connection

FuzzyLookup configuration: Open the Fuzzy Lookup Transformation Editor. Set the OLE DB Connection Manager in the Reference tab to use the AdventureWorksDW database connection and the Occupation table. Set up the Columns tab by connecting the input to the reference table columns as in below image, dragging the Title column to the occupationLabel column on the right. Set up the Advanced tab with a Similarity threshold of 50 (0.50).

Output:

The output will be something similar to below image. You can compare the source value and the lookup value and the other Fully Lookup related columns.

Cheers!
Uma