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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.