O'Reilly logo

Microsoft® SQL Server® 2012 Integration Services by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

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 9. Data Cleansing Using SSIS

SQL Server Integration Services provides great support for handling data quality. It offers a rich set of built-in functionality and seamless interoperability with other data quality features in SQL Server and partner solutions. You can perform comprehensive data quality management integrated with data integration processes using the profiling and cleansing capabilities available in SSIS. This is especially useful in integration scenarios involving multiple data stores with duplicate, inconsistent, or incorrect data. Let’s look at the data profiling and cleansing capabilities ...

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