Chapter 8. Creating a Robust and Restartable Package
Exam objectives in this chapter:
Extract and Transform Data
Manage SSIS package execution.
Load Data
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, ...
Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 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.