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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
