1. Drag and drop the Recordset Destination data flow component from the
Data Flow Destinations group on to the canvas.
2. Right-click on the Percentage Sampling Data Flow item and from the
drop-down choose Add Path.
3. Connect the Percentage Sampling Component's "Selected Sampling Output"
to the Recordset Destination.
Step 9: Configure the Recordset Destination
Data Flow Component
1. Right-click the Recordset Destination Data Flow component and from the
drop-down list, click on variables to open the variables window.
2. In the variables window, click on Add Variable. Type in, or choose items as
shown in the next screenshot (for details refer to the previous chapters).
3. Right-click the Recordset Destination Data Flow component and from the
drop-down choose Edit??¦.
Using an Aggregate Data Transformation
[ 156 ]
This opens the Advanced Editor for Recordset Destination. In the Component
Properties page, associate the above added variable Agg with the VariableName
in the Custom Properties node, as shown in the next screenshot.
4. Click on the Input Columns tabbed page and you should see both the
ProductID and the UnitPrice selected in a two pane window.
If needed, you may change the Output aliases. If you do not, the default will
be used. For this exercise, the Output alias for the UnitPrice column is chosen
as, Sum [Unit Price] and Product ID for ProductID.
5. Click on the OK button on the Advanced Editor for Recordset Destination.
Pages:
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120