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

Getting ready

For this recipe, you will need DQS and Data Quality Client installed. Please refer to the following link to learn how to install the DQS components: https://docs.microsoft.com/en-us/sql/data-quality-services/install-windows/install-data-quality-services.

You also need to prepare the data you will use to create a DQS KB. In SSMS, execute the following code:

USE AdventureWorksDW2014;SELECT DISTINCTCity, StateProvinceName AS StateProvince,EnglishCountryRegionName AS CountryRegionINTO dbo.AWCitiesStatesCountriesFROM dbo.DimGeography;GO

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