Control Flow
Control Flow is part of SQL Server Integration Services Package
where you handle the flow of operations or Tasks. Let's say you are reading a
text file by using Data Flow task from a folder. If Data Flow Task completes
successfully then you want to Run File System Task to move the file from Source
Folder to Archive Folder. If Data Flow Task failed then you want to sen
d email
to your users by using Send Mail Task. The Precedence Constraints are used to
control the execution flow.
Data Flow
Data Flow is the part of SQL Server Integration Services
Package, where data is extracted by using Data Flow Sources (OLE DB Source, Raw
File Source, Flat File Source, Excel Source etc.). After extracting data Flow
Transformations such as Data Conversion, Derived Column, Lookup, Multicast,
Merge etc are used to implement different business logic and finally written
to Data Flow Destinations (OLE DB Destination, Flat File Destination, Excel
Destination, Data Reader Destination ADO NET Destination etc.)