Chapter 6. Enhancing Control Flow

Exam objectives in this chapter:

  • Load Data

    • Design control flow.

    • Implement package logic by using SSIS variables and parameters.

    • Implement control flow.

Microsoft SQL Server Integration Services (SSIS) solutions are automated solutions—their operation requires no user interaction whatsoever; in fact, in all the activities surrounding SSIS solutions, the human presence is limited to development (obviously), deployment (for example, when solutions are initially set up in production or when new versions of the solutions are set up), and maintenance (for example, to reconfigure a solution, to analyze its operation, or to troubleshoot it).

This significant characteristic has a profound effect on SSIS development; every process ...

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.