Using a Conditional Split Data Transformation
[ 140 ]
Step 5: Add Recordset Destination(s)
Although the three streams of data can be channeled to any of the different Data
Flow Destination types that we have already used in the previous chapters, we will
do something a little different here.
When a Recordset Destination component is used in the SSIS designer, an in-memory
ADO (ActiveX Data Objects) recordset is created and populated. A Recordset
Destination requires a variable to be defined where the ADO recordset is going to
be stored. The variable name is a string you specify at design time. You may use this
variable outside the data flow to be consumed by other elements or used in scripts.
It has one input and no error output.
1. Drag and drop (or alternately double-click in the Toolbox) a Recordset
Destination component into the Data Flow page of the canvas. "Canvas".
2. Right-click the Conditional Split component and choose Add Path.
This opens the Data Flow window displaying the "From:" as Conditional
Split.
3. Click on the drop-down arrow head in the "To:" window. In the drop-down,
you will see three options. Choose Recordset Destination. Click on the OK
button in the Data Flow window.
This opens the Input Output Selection window with the input displaying
"Recordset Destination" and the output from the conditional shows all the
previously configured splits as shown in the following screenshot.
4. Click on Case 1 and click on the OK button in the Input Output
Selection window.
Pages:
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111