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 ...
