What is Control Flow and Data Flow in SSIS?

By: Jimit Shah | Views: 1487 | Date: 19-Jul-2011

Here we have provided overview of Control Flow and Data Flow in SSIS.

Control Flow in SSIS:

A control flow consists of one or more tasks and containers that execute when the package runs. To control order or define the conditions for running the next task or container in the package control flow, you use precedence constraints to connect the tasks and containers in a package. A subset of tasks and containers can also be grouped and run repeatedly as a unit within the package control flow.

SQL Server 2005 Integration Services (SSIS) provides three different types of control flow elements: containers that provide structures in packages, tasks that provide functionality, and precedence constraints that connect the executables, containers, and tasks into an ordered control flow.

Data Flow in SSIS:

A data flow consists of the sources and destinations that extract and load data, the transformations that modify and extend data, and the paths that link sources, transformations, and destinations. Before you can add a data flow to a package, the package control flow must include a Data Flow task. The Data Flow task is the executable within the SSIS package that creates, orders, and runs the data flow. A separate instance of the data flow engine is opened for each Data Flow task in a package.

SQL Server 2005 Integration Services (SSIS) provides three different types of data flow components: sources, transformations, and destinations. Sources extract data from data stores such as tables and views in relational databases, files, and Analysis Services databases. Transformations modify, summarize, and clean data. Destinations load data into data stores or create in-memory datasets.
Previous Page Next Page

People Searching On This Page:
  • ssis controlflow if condition
  • variety.control email loc:IN
  • flow board for sql
  • what is control flow and data flow
  • ssis dataflow vs controlflow
  • what is control and data flow in sql
  • google ssis dataflow control flow
  • what is control flow containers
  • what is control flow of data
  • explain control flow vs data flow
  • what is control flow and dataflow
  • define control flow and data flow
  • control vs data flow in ssis
  • ssis control flow vs data flow
  • SSIS variables control flow share data flow

Related Pages


What is Flow measurement

What is Flow measurement

Articles | Engineering
Date:
27-Jan-2012  Views: 2639

Flow measurement is the quantification of bulk fluid movement. Flow can be measured in a variety of ways. Positive-displacement flow meters accumulate ...
DTS vs SSIS - Data Transformation Services vs SQL Server Integration Services

DTS vs SSIS - Data Transformation Services vs SQL Server Integration Services

Articles | Programming | MS SQL
Date:
19-Jul-2011  Views: 2155

Here we have provided some differences between DTS and SSIS. It may be useful to answer interview question related to SSIS (MSBI) ...
Flower Wrap and Gift Wrap by Italpak

Flower Wrap and Gift Wrap by Italpak

Articles | Business | International Business
Date:
05-Jun-2011  Views: 1390

Italpak Srl. is an Italian Company that produce decorative packaging, as gift wrap, flower wrap and window dressing ...
Avail Mortgage Assistance Program and Save Your Home from Foreclosure

Avail Mortgage Assistance Program and Save Your Home from Foreclosure

Articles | Advertising
Date:
21-Apr-2011  Views: 1168

Mortgage assistance program are of two types and if availed through the right channel and with the right amount of preparation then the individual can ...
List of National Flower Of All Country with Interesting Facts

List of National Flower Of All Country with Interesting Facts

Articles | General Knowledge
Date:
13-Apr-2010  Views: 33553

In a number of countries, plants have been chosen as symbols to represent specific geographic areas. Some countries have a country-wide floral emblem; ...
Post Your Comments (No Login Require)
Name : (required)
Email : (required)
Website :

Comment : (required)

26  + 3 =     
Comments
People Searched About:
Ssis Controlflow If Condition   |   Variety.Control Email Loc:IN   |   Flow Board For Sql   |   What Is Control Flow And Data Flow   |   Ssis Dataflow Vs Controlflow   |   What Is Control And Data Flow In Sql   |   Google Ssis Dataflow Control Flow   |   What Is Control Flow Containers   |   What Is Control Flow Of Data   |   Explain Control Flow Vs Data Flow   |   What Is Control Flow And Dataflow   |   Define Control Flow And Data Flow   |   Control Vs Data Flow In Ssis   |  
Google : 630 times | Yahoo : 71 times | Bing : 242 times |