- The smallest unit in Control Flow is task whereas smallest unit in Data Flow is component
- In Control FLow , Tasks require completion (success, failure or completion) before moving to next task. In Data Flow , one component will not wait for other component to finish, all of them will work together in processing and managing data in streaming way.
What is difference between Control Flow and Data Flow in SSIS ?
Difference between Control Flow and Data Flow in SSIS are as follows :
Subscribe to:
Post Comments (Atom)
Popular Posts
-
RegisterStartUpScript This adds the javascript code at the end of the page before the closing of form tag. RegisterClientScriptBlock Th...
-
delegate string Delegate1(object o); delegate object Delegate2(string s); static string Dispaly(object o) { r...
-
@@ERROR is a global variable used to return error number of last T-SQL.
-
Please follow below steps to enable transaction in Web Service : 1.Add a reference to System.EnterpriseServices.dll. 2.Add the System.Ente...
-
Authentication is process of obtaining credentials such as username and password and validating the credentials. There are 3 types of ASP....
-
window.open
-
To be in second normal form i.e 2NF , all information attributes or fields of the table are attributes of entity of table schema. All inform...
-
Replication is the way to keep data synchronised in multiple datbases. SQL Replication consists of two important part : Publisher - Datab...
-
The WebMethod attribute in Web Service provides the following properties: BufferResponse CacheDuration Description EnableSession Messa...
-
Computed Column is virtual column in table whose value is computed at runtime.The values are not stored in table but computed by the express...
No comments:
Post a Comment