Categories of Control Flow Tasks
Though the Toolbox in BI Development Studio (BIDS) shows Control Flow Tasks in two main groups, the Control Flow tasks can be categorized on the basis of the functionality they provide. Read through the following introductions quickly to understand how these tasks are categorized and organized in the control flow. You can reread this section whenever you need a quick description of a task.
Data Flow Task
This main task performs ETL (extracting, transforming, and loading) operations using the data flow engine.
| Control Flow Task | Description |
|---|---|
|
| Perform the ETL functions—i.e., extract data from a source, apply transformations ... |
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.
