SSIS Dataflow Task

SSIS Dataflow Task

Overview

The SSIS Dataflow task is the real core of SSIS. It is used to move data between heterogeneous data sources - in layman's terms it moves data from one place to another.

The SSIS Dataflow task differs from all of the other SSIS tasks in that it has a dedicated runtime engine, conveniently called the Dataflow engine. (In fact the Dataflow task and the Dataflow engine can be considered synonymous with one another.) The Dataflow engine is a powerful component, capable of moving data from one place to another very efficiently and thus very quickly. 

Make-up of a Dataflow task

A dataflow is ostensibly a collection of SSIS components, connected together. These components can be one of the Data Flow Sources, Data Flow Transformations, or Data Flow Destinations.
The Data Flow Sources are source components in the Data Flow. The Dataflow Engine can read from these, and put the data to the component's output. A Data Flow Source can be XML, Excel, or a flat file, or any databases which can be queried via OLE DB or ADO.NET. There is a special format, the Raw File Source, which is the native format of Integration Services.
The Data Flow Destinations are the targets of the data. The types of the sources can be found here as well (XML, Excel, flat and raw files, ADO.NET and OLE DB destinations), but there are a few additional types. These are the Data Mining Model Training, the Data Reader Destination, Dimension Processing, Partition Processing, Recordset Destination, SQL Server Compact Destination and SQL Server Destination.
Between its source and destination the data usually needs transformations during an ETL process. There are a lot of transformations implemented already (29 in SQL Server 2008 R2), but if none of these can help in a transformation, the Script Component enables the developer to embed custom C# or VB.NET code to solve the remaining tasks.
For the complete list of available built-in transformations, please visit the following article: SSIS: List of transformations.

For the official documentation of the Data Flow Task, see the Data Flow topic in Books Online.

Leave a Comment
  • Please add 6 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Ed Price MSFT edited Revision 10. Comment: Removed link to self.

  • Ed Price MSFT edited Revision 8. Comment: Minor formatting edits.

  • Ed Price MSFT edited Revision 5. Comment: Changed links to the SQL Server Integration Services page instead of the acronym page.

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price MSFT edited Revision 5. Comment: Changed links to the SQL Server Integration Services page instead of the acronym page.

  • Ed Price MSFT edited Revision 8. Comment: Minor formatting edits.

  • Ed Price MSFT edited Revision 10. Comment: Removed link to self.

  • Zoltán Horváth edited Revision 13. Comment: added link to new content -  list of transformations

  • Great work

Page 1 of 1 (5 items)