Tuesday, September 18, 2012

Control Flow Task in SSIS

Control flow task is the starting point of package design. It’s the first step or window which developer opens while designing the package. Package control flow task contains the package workflow where entire flow of multiple tasks designed.


The Control Flow tab in the Package Designer Window of BIDS is used to design workflow for the tasks that constitute the package. In control flow the process flows of multiple tasks. The containers like for loop, Sequential and for each loop are used to design the process. Data flow task is a sub task of control flow task where data can be transferred between two data servers. Tasks are added to the control flow via the Toolbox. Double-clicking the task in the Control Flow window will open the Task Editor, which is used to configure the Task.

Control is compulsory part of package design.


No comments:

Post a Comment