Chapter 8. Creating a Robust and Restartable Package
Exam objectives in this chapter:
Extract and Transform Data
Manage SSIS package execution.
Design control flow.
Implement control flow.
Configure and Deploy SSIS Solutions
Implement auditing, logging, and event handling.
Package development and implementation goes beyond just using transformations to apply the necessary logic to transfer data from sources to destinations. You must also implement error handling, and you must test and troubleshoot your packages as you develop them. As you learned in previous chapters, Microsoft SQL Server 2012 Integration Services (SSIS) provides several ways to handle errors at different levels of the SSIS architecture. For example, at the control flow level, ...