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.
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 another step named Get rows from result. By calling the Transformation that gets the rows right after the Transformation that copies the rows, you get the same result as having all steps in a single Transformation.
Let's see how this works with a simple example. We will read a file...