Configure the Conditional Split Data Transformation.
Add Recordset Destination(s).
Configure the Recordset Destination(s).
Build, 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
Creating a BI project, changing the name of the default Package, adding a
DataReader Source, and configuring it to provide at its output data selected from
the database has been described in the previous chapters.
1. Create a BI project Ch 8 and change the default name of the package to
splitter.dtsx. Add a DataReader Source and provide it with a connection
manager [LocalHost.MyNorthwind.sa] that retrieves data from the Local
SQL Server.
2. Configure the DataReader Source with the following SQL statement for
retrieving the data. Select * from [Order Details].
3. The following screenshot shows the result of running this query directly in
the query window of the SQL Server Management Studio.
??? ??? ??? ??? ???
Chapter 8
[ 137 ]
Step 2: Add a Conditional Split Transformation
The data output from the DataReader Source will be the input to the conditional split
transformation. In a Conditional Split Data Flow Transformation, the data flow is
read and depending on the conditions and their order of implementation you define,
the data is split into components that satisfy those conditions. Those that do not
satisfy are separated out into another data flow.
Pages:
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108