Knight's Microsoft SQL Server 2012 Integration Services 24-Hour Trainer

Section 2

Control Flow

• Lesson 9: Using Precedence Constraints
• Lesson 10: Manipulating Files with the File System Task
• Lesson 11: Coding Custom Script Tasks
• Lesson 12: Using the Execute SQL Task
• Lesson 13: Using the Execute Process Task
• Lesson 14: Using the Expression Task
• Lesson 15: Using the Send Mail Task
• Lesson 16: Using the FTP Task
• Lesson 17: Creating a Data Flow

Chapter 9

Using Precedence Constraints

Figure 9-1

When using tasks in SQL Server Integration Services (SSIS), you need a way to connect these tasks in most cases. Precedence constraints are the connections between the tasks that control the execution order of each task. After you drag in more than one task in the Control Flow in SSIS, you can link them together by using these precedence constraints. Click once on a task, and you see a green arrow pointing down from the task; this is the precedence constraint line for this task. For example, in Figure 9-1, you can see a Script Task with a green arrow below the task. This is the precedence constraint arrow to connect to the next task you need to run after this task completes successfully. These arrows control the order of tasks in a package, and they also control whether tasks will run at all.

Figure 9-2

To create an On Success Precedence Constraint, click ...