Chapter 9. Detecting and Handling Processing Errors
After completing this chapter, you will be able to:
Understand basic methods of error detection and handling.
Create and configure event handlers to respond to events that are raised at run time.
Use transactions to maintain data integrity.
Use checkpoint restarts to restart failed packages.
In Chapter 8, you learned how to monitor and update the values of properties at run time without having to modify the actual package. You also learned several ways to execute a package and how to use Microsoft SQL Server Integration Services (SSIS) logging to monitor package execution. In this chapter, you’ll learn how to detect and handle the processing errors that can occur when packages are designed and executed. ...
Get Microsoft® SQL Server™ 2005 Integration Services Step by Step 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.
