What are all the Data Flow Tasks?

What are all the Data Flow Tasks? 

  
This Tasks is used to extract the data from one or more data sources, performing
transformations and load the data into one or more destination data sources.
 
The following list of Sources are provided by the SSIS.

• Flat File Source
• Raw File Source
• Excel Source
• OLEDB Source
• Data Reader Source
• XML Source

Flat File Source :
Flat Files are character based text Files.Default data storage format is ASCII
We have two Types of Flat files

• Delimited Flat Files - Row delimeter 
• Fixed with Flat Files- Column delimeter 

 Fixed width Delimeter:
          In this every field length will be fixed. It has three sub types. Those are

• Ordinary Fixed Width
• Row Delimited Fixed Width
• Ragged Right Fixed Width

 Ordinary Fixed Width: In this every field length will be fixed.

Row Delimetered Fixed Width: Every field length will be fixed and row separated by comma

Ragged Right Fixed Width: Same as Row Delimetered fixed width, but fixed width   behavior  not applies for last fixed in every row.       

RAW File Source:
These files are same as Flat Files. Meanwhile it has  three differences
It contains Binary Content also.
It does not used connection manager
It  gives better performance.


Excel Source : 
The Excel source extracts data from worksheets or ranges in Microsoft Excel workbooks.The
Excel source provides four different data access modes for extracting data:

• A table or view.
• A table or view specified in a variable.
• The results of an SQL statement. The query can be a parameterized query.
• The results of an SQL statement stored in a variable.

OLEDB Data Source : 
OLEDB adapters can extract the data from any RDBMS and can load the data into any RDBMS.OLEDB providers has to be selected to work with RDBMS.


Data Reader Source:
The DataReader source consumes data from a .NET provider and makes the data available to the data flow.We can configure the DataReader source by providing the SQL statement that defines  the result set. For example : A DataReader source that connects to the Adventure Works database and uses  the SQL statement SELECT * FROM Production.Product extracts all the rows from the Production.Product table and provides the dataset to a downstream component.The DataReader source supports the System.Object data type by converting columns that have this data type to the DT_NTEXT Integration Services data type.
    
XML Source :

The XML source reads an XML data file and populates the columns in the source output with the data. The data in XML files frequently includes hierarchical relationships. For example, an XML data file can represent catalogs and items in catalogs. Before the data can enter the data flow, the relationship of the elements in XML data file must be determined, and an output must be generated for each element in the file.The XML source uses a schema to interpret the XML data.The XML source supports use of a XML Schema Definition (XSD) file or inline schemas to translate the XML data into a tabular format.