In order to Perform ETL using SSIS Data Flow Task or DFT plays an important role. DFT is responsible for Movement of Data from Source-to-Stage or from Stage-to-Mart. DFT has three main components

  • a) Source
  • b) Transformation
  • c) Destination

Below image show an empty Data Flow Task.
SSIS_DFT

  • 1) Depending upon source from where we need to Extract the data, The source is selected from different Sources e.g. Excel, Flat File, OLE DB, RAW file, XML etc.
  • 2) A suitable Transformation is selected
  • 3) Finally Depending upon requirement The suitable Destination is selected.