SQL Server 2012 Data Quality Services
Microsoft® SQL Server® 2012 Data Quality Services (DQS) is a new offering as part of SQL Server 2012 allowing customers to cleanse, de-duplicate, standardize, and enrich their data to deliver trusted information for business intelligence, data-warehouse, and transaction processing workloads.
It is a user-driven, computer-assisted solution to identify incorrect or incomplete data and modify, remove, or enrich that data to resolve data quality issues.
You can integrate DQS as a component of SQL Server Integration Services (SSIS) and into Master Data Services (MDS) work-flows. The SSIS data cleansing transformation applies rules that have already been configured in DQS to a data flow. This allows users to send data from a SSIS work-flow to cleanse before sending to the target destination.