This completes the Recordset Destination editor configuration.
6. Right-click on the path from Aggregate Data Flow item to the Percentage
Sampling Data item and add a Grid type Data Viewer as described in a
Chapter 6.
7. Similarly, add a Grid type Data Viewer to the path from Percentage
Sampling Data Flow item to the Recordset Destination.
Step 10: Build and Execute the Package, and
Review Results
Build the project and execute the package. The program runs and after a while you
will see that the DataReader Source turns green while Aggregate and Percentage
Sampling are yellow. 2155 rows transferred to the Aggregate which has produced 77
grouped outputs. The Aggregate output is displayed in the following Data Viewer
shown next (only part of it is shown).
Chapter 9
[ 157 ]
1. Click on the green arrow head in the Aggregate Output 1 Data Viewer1 at
Aggregate.Aggregate Output 1 window.
This opens the path for the second data viewer as shown in the next screenshot,
wherein 15 rows are passed from the Percentage Sampling component to the
Recordset Destination. The number of rows that are picked by the Percentage
Sampling depends on a random algorithm.
Using an Aggregate Data Transformation
[ 158 ]
Summary
This chapter described details of a package with an Aggregate Data Transformation
followed by a Percentage Sampling component. Recordset Destination, together
with data viewers, provided visual confirmation of the success of this package.
Pages:
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121