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

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