Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2012 Andy Leonard, Matt Masson, Tim Mitchell, Jessica M. Moss, and Michelle Ufford
About this chapter
Cite this chapter
Leonard, A., Masson, M., Mitchell, T., Moss, J.M., Ufford, M. (2012). Data Cleansing with Data Quality Services. In: SQL Server 2012 Integration Services Design Patterns. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3772-3_5
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3772-3_5
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3771-6
Online ISBN: 978-1-4302-3772-3
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books