Chapter 8
[ 141 ]
5. At this point, the canvas appears as shown in the following screenshot. The
Recordset Destination is not completely configured as yet.
6. Similar to the above, add two more Recordset Destinations, one each for
"Case2" and the "SplitDefault" data.
Step 6: Configure the Recordset Destination(s)
1. Right-click the Recordset Destination (the first one added) component in the
canvas and choose the drop-down menu item Variables.
2. This opens the Variables window as shown in the next screenshot where
we need to associate this recordset with a variable. A variable carries the
information in the in-memory recordset and that is the reason we need to
associate a variable with the recordset destination.
Using a Conditional Split Data Transformation
[ 142 ]
3. Click on the Add symbol in the Variables window.
4. In the Variables window, change the default values as follows: variable in
Name to Test1 [no space between Test and 1] by typing it in; int32 to Object
(choose from drop-down menu) since recordset's data type is object in Scope.
The Data Type will display Object, and Value will display System.object.
A completed view of this window is presented later.
5. Now right-click the Recordset Destination and choose Edit??¦.
This opens the Advanced Editor for Recordset Destination as shown in the
following screenshot. For VariableName line item type in Test1 by its side,
as shown. If you did not configure a variable and try to proceed to the next
tab you will be faced with an error.
Pages:
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112