The Data Flow Engine, also called the SSIS pipeline engine, is responsible for managing the flow of data from the source to the DESTINATION and performing transformations (lookups, data cleansing ETC.). Data flow USES memory oriented architecture, called buffers, during the data flow and transformations which allows it to execute extremely fast. This means the SSIS pipeline engine PULLS data from the source, stores it in buffers (in-memory), does the requested transformations in the buffers and writes to the destination. The BENEFIT is that it provides the fastest transformation as it happens in memory and we don't need to stage the data for transformations in most cases.

 The Data Flow Engine, also called the SSIS pipeline engine, is responsible for managing the flow of data from the source to the destination and performing transformations (lookups, data cleansing etc.). Data flow uses memory oriented architecture, called buffers, during the data flow and transformations which allows it to execute extremely fast. This means the SSIS pipeline engine pulls data from the source, stores it in buffers (in-memory), does the requested transformations in the buffers and writes to the destination. The benefit is that it provides the fastest transformation as it happens in memory and we don't need to stage the data for transformations in most cases.