Chapter 23. Troubleshooting Data Issues

An important feature of any mission-critical system is to provide the ability to identify failure or error in an operation, investigate the reasons, and allow users to take actions. Data integration projects often deal with important data and any error in data reading, processing, or writing can potentially lead to serious mistakes in business decisions. Hence troubleshooting data issues is an essential feature of data integration software. SSIS, as an enterprise-class data integration platform, has the capabilities to help with troubleshooting issues such as wrong data or incorrect number of rows loaded ...

Get Microsoft® SQL Server® 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.