Data Flow Paths

First, let me remind you how you connect tasks in the control flow. You click the first task in the control flow to highlight the task and add a green arrow, representing output from the task. Then you drag the green arrow to the input of the next task in the downstream to create a connection between the tasks, represented by the green line by default. The green line, called a precedence constraint, enables you to define some conditions when the following tasks can be executed. In the data flow, you connect the components in the same way you did in the control flow—drag the output of a data flow component and drop it on to the input of the next component, and the line formed connecting the data flow components on the Data Flow ...

Get Hands-On Microsoft SQL Server™ 2005 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.