Control
Flow:
1. Process Oriented
2. Doesn’t manage or
pass data between components.
3. It functions as a
task coordinator
4. In control flow
tasks requires completion (Success, failure or completion)
5. Synchronous in
nature, this means, task requires completion before moving to next task. If the
tasks are not connected with each other but still they are synchronous in
nature.
6. Tasks can be
executed both parallel and serially
7. Three types of
control flow elements in SSIS 2005
· Containers:
Provides structures in the packages
· Tasks: Provides
functionality in the packages
· Precedence Constraints: Connects
containers, executables and tasks into an ordered control flow.
8. We can control
the sequence execution for tasks and also specify the conditions that tasks and
containers run.
9. It is possible to
include nested containers as SSIS Architecture supports nesting of the
containers. Control flow can include multiple levels of nested containers.
Data Flow
•Streaming in nature
•Information oriented
•Passes data between other components
•Transformations work together to manage and process data. This
means first set of data from the source may be in the final destination step
while at the same time other set of data is still flowing. All the
transformations are doing work at the same time.
•Three types of Data Flow components
· Sources: Extracts data
from the various sources (Database, Text Files)
· Transformations:
Cleans, modify, merge and summarizes the data
· Destination: Loads data
into destinations like database, files or in memory datasets
No comments:
Post a Comment