Chapter 4. Designing and Implementing Control Flow
Exam objectives in this chapter:
Extract and Transform Data
Define connection managers.
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 ...