Chapter 8
[ 143 ]
6. Click on the Input Columns tab to open the Input Columns window. Place
a check mark for the columns that you want into the recordset (all are chosen
for this exercise) as shown in the following screenshot. Click on the Refresh
button to refresh the data.
7. If you want, you may choose fewer columns as well as their output aliases.
8. Click on the OK button because this type of destination does not have an
output and no need to go to the next tab, Input and Output Properties.
This completes the configuration of the Recordset Destination that will have
the data channelled by Case 1.
Using a Conditional Split Data Transformation
[ 144 ]
9. Repeat the same procedure for the other two outputs from the Conditional
Split, Case 2 and SplitDefault.
The completed design in the canvas should appear as shown in the
following screenshot.
The associated Variables window with this task should appear as in the
following screenshot.
Chapter 8
[ 145 ]
Step 7: Build, Execute the Package and Review
Build the project and execute the package, similarly to hie you did in other chapters.
The program runs, and after a while you will see that all the objects turn green,
indicating success as shown in the following screenshot. You will also see that
828 records went to the Recordset Destination for Case 1, and 1317 records went
over to Case 2 making a total of 2155 rows. None went to the default. You may
verify whether this is correct by running suitable select queries [for example, select
count(*)from [Order Details] where Discount > 0] in the SQL Server.
Pages:
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113