Mastering SQL Server 2017

How to do it...

1. In SSMS, create a new table in the DQS_STAGING_DATA database in the dbo schema and name it dbo.FuzzyMatchingResults. Use the following code:

CREATE TABLE dbo.FuzzyMatchingResults(  CustomerKey INT NOT NULL PRIMARY KEY,  FullName NVARCHAR(200) NULL,  StreetAddress NVARCHAR(200) NULL,  Updated INT NULL,  CleanCustomerKey INT NULL);

2. Switch to SSDT. Continue editing the DataMatching package.
3. Add a fuzzy lookup transformation below the no match multicast transformation. Rename it FuzzyMatches and connect it to the no match multicast transformation with the regular data flow path. Double-click the transformation to open its editor.
4. On the Reference Table tab, select the connection manager you want to use to connect to your DQS_STAGING_DATA ...