Chapter 4. Designing and Implementing Control Flow

Exam objectives in this chapter:

  • Extract and Transform Data

    • Define connection managers.

  • Load Data

    • Design control flow.

    • Implement control flow.

In the previous chapter, it was established that Microsoft SQL Server Integration Services (SSIS) facilitate data movement. Of course, the functional capabilities available in SSIS are not limited to data movement alone—far from it! In its essence, SSIS provides a framework for developing, deploying, and automating a wide variety of processes. Setting data movements aside for the moment, here are a few examples of other management processes facilitated by SSIS solutions:

  • File system and FTP access. For data that resides in or is transported by using files, the ...

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 live online training, plus books, videos, and digital content from nearly 200 publishers.