O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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);
  1. Switch to SSDT. Continue editing the DataMatching package.
  2. 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.
  3. On the Reference Table tab, select the connection manager you want to use to connect to your DQS_STAGING_DATA ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required