Roadmap › SSIS — SQL Server Integration Services › Module: Package Basics
Lessons in this course (13)
1. Package anatomy: control flow vs data flow
Basic★ Must knowLesson 1 of 13
| Control Flow | Data Flow |
|---|---|
| Workflow of tasks | Row-by-row pipeline inside one Data Flow Task |
| Elements: tasks, containers, precedence constraints | Elements: sources, transformations, destinations, paths |
| Runs tasks one after another (or in parallel) | Streams data through memory buffers |
| Handles files, SQL commands, emails, loops | Extracts, transforms, loads rows |
Common Control Flow tasks: Execute SQL Task, Data Flow Task, Execute Package Task, File System Task, FTP Task, Script Task (C#), Send Mail Task, Expression Task, Bulk Insert Task, Execute Process Task, Web Service Task, XML Task, CDC Control Task, Analysis Services Processing Task, maintenance plan tasks.
Containers: Sequence (group tasks, scope variables, shared transactions), For Loop (counter-based), Foreach Loop (enumerators: File, ADO recordset, Item, Variable, SMO, Azure Blob...), and the implicit Task Host around each task.