Abstract
Data Quality Services (DQS) was first introduced in SQL Server 2012. It provides data correction and data deduplication functionality—key components for most Extract, Transform, and Load (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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Andy Leonard
About this chapter
Cite this chapter
Leonard, A., Mitchell, T., Masson, M., Moss, J., Ufford, M. (2014). Data Correction with Data Quality Services. In: SQL Server Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0082-7_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0082-7_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0083-4
Online ISBN: 978-1-4842-0082-7
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books