Posts Tagged ‘Data Flow’

The SSIS Package Designer

April 27th, 2010 by aabhaanjan

The SSIS Package designer contain design pane where we create or design our DTS package .The SSIS package designer tool provide a way to create a workflow which represent how the data flow .The Designer include four  tabs

1. Control folw

2.  Data Flow

3. Event Handlers

4. Package Explorer


Control Flow :- It contain workflow parts of the package .Control flow give a pictorial representation how the data flow from heterogeneous source. Control flow also include Task and constraints (Success , failure)

Control Flow include :-

  1. Tasks: – Task basically unit of work.
  2. Constraints :-Evaluate success , failure and completion

Data Flow :- It contain the data flow task ,it define how the data flow from source to destination .Data Flow task includes Data Flow Source, Data Flow Transformation, Data Flow Destination .

  1. Data Flow Source :-The Data Flow Source is the source from where you want to transfer the data .such as DataReader source,Excel Source,OLEDB Source etc .
  2. Data Flow Transformation :-Data Flow transformation provide a way to cleaning the data .Transformation can perform task such as updating ,cleaning , mearging and distributing data.Such as Fuzzy Lookup,Data conversion,Conditional split etc .
  3. Data Flow Destination :- A destination is component that store or move the data to a specific data stores .such as OLE DB Destination etc

3. Event Handlers :- The Event handlers allow you to handle errors or changes in events .

4. Package Explorer: – The Package explorer tab all the package designiner view to a single view . Package Explorer show the connection manager which you have already configured during in data flow or control flow .

Executing Package :- The final step of SSIS package is executing a package by clicking F5.

Tags: , , , ,