C H A P T E R  5

Control Flow Basics

You cannot always control what goes on outside. But you can always control what goes on inside.

—Self-help advocate Wayne Dyer

The previous chapter introduced you to SQL Server 11’s connection managers. The purpose of this chapter is to introduce some of the basic control flow items that will enable you to utilize those connection managers. The control flow has its own designer page in the Designer window in Visual Studio. In this chapter, we detail the control flow tasks that you are most likely to use on a daily basis. Chapter 6 covers the less frequently used executables. The control flow defines the operations that a package performs, and the order and conditions required to execute them.

What Is a ...

Get Pro SQL Server 2012 Integration Services 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.