Making the data flow between transformations

In this section, you will learn a very simple but useful technique to allow the data flow from one Transformation to another. In other words, you will learn to create a very simple process flow.

For this tutorial, we will continue using the sample file that we just used to learn about sub-transformations.

Transferring data using the copy/get rows mechanism

The copy/get rows mechanism allows you to transfer data between two Transformations, creating a process flow. The following figure shows you how it works:

Copying and getting rows

There is a Copy rows to result step that transfers your rows of data to the outside of the Transformation. Then you can pick that data using...