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

This recipe assumes that you have built the DQS knowledge base from the previous recipe. In addition, you need to prepare some demo data in advance. In SSMS, use the following query to prepare the data:

USE DQS_STAGING_DATA;SELECT C.CustomerKey,C.FirstName + ' ' + c.LastName AS FullName,C.AddressLine1 AS StreetAddress,G.City, G.StateProvinceName AS StateProvince,G.EnglishCountryRegionName AS CountryRegion,C.EmailAddress, C.BirthDate,C.EnglishOccupation AS OccupationINTO dbo.CustomersCh05FROM AdventureWorksDW2014.dbo.DimCustomer AS CINNER JOIN AdventureWorksDW2014.dbo.DimGeography AS GON C.GeographyKey = G.GeographyKeyWHERE C.CustomerKey % 10 = 0;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