It contains lots on Business Intelligence scenarios and solutions along with real problems regarding Microsoft Excel, SQL Server Reporting Services, SQL Server Integration & Analysis Services and various databases and also may contain other popular posts.

Saturday, 7 January 2017

Difference Between Control Flow and Data Flow In SSIS

Control Flow Tabis a separate tab in a SQL Server Integration Services package which contains various tasks, executable and containers to execute the flow of operations and tasks. All the tasks, executable and containers are connected by Precedence Constraints which has constraint (Success, Failure or completed) and expressions . In Control Flow Tab one task need to be completed to execute next task. So basically Control Flow is process oriented and handle the execution flow.

(Figure 1 - Control Flow Tab)

Data Flow Task is part of Control Flow Tab which handle flow of the data from source to destination by including various transformations and business logic. Data Flow Tab is made up through Sources, Transformations and Destinations and none of it's component will wait for other's to complete. So basically Data Flow Task is information oriented and handle the data flow.