Add a Percentage Sampling Data Transformation.
Establish a path from Aggregate Data Transformation to the Percentage
Sampling Data Transformation.
Configure the Percentage Sampling Data Flow Item.
Add a Recordset Destination Data Flow component.
Configure the Recordset Destination Data Flow Component.
Build and execute the package, and review results.
Step 1: Create a BI Project and Add a Data
Flow Task. Add and Configure the DataReader
Source to Pull Data from the Local
SQL Server
1. Create a BI project Ch 9, change the name of the default Package to
aggregate.dtsx, add a DataReader Source and configure it to provide at its
output, data selected from the database with the following SQL statement:
Select * from [Order Details] order by ProductID
(The output of this query without the sort is shown in Chapter 6.)
Step 2: Add an Aggregate Data Transformation
The data output from the DataReader Source will be the input to the aggregate
transformation. In the aggregate transformation's editor, the aggregation details will
be set.
1. Drag and drop an Aggregate Data Flow item from the Data Flow
Transformations group in the Toolbox to the Data Flow page of the canvas.
??? ??? ??? ??? ??? ??? ??? ??? ??? ???
Using an Aggregate Data Transformation
[ 150 ]
Step 3: Establish a Path to Connect
DataReader Source with the Aggregate
Data Transformation
1. Right-click the Data Reader Source and from the drop-down click on
Add Path.
Pages:
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116