O'Reilly logo

SQL Server 2012 Integration Services Design Patterns by Michelle Ufford, Matt Masson, Jessica M. Moss, Andy Leonard, Tim Mitchell

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

CHAPTER 5

image

Data Cleansing with Data Quality Services

Data Quality Services (DQS) is a new product in SQL Server 2012 that provides data cleansing functionality – a key component for most ETL processes. This chapter describes how DQS integrates with SSIS, and provides patterns that enable you to achieve reliable, low effort data cleansing within your ETL packages.

image Note  The Data Quality Services product requires some manual steps post-installation to create the DQS ­databases, and set default permissions. See the “Installing Data Quality Services” ...

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