Database Reference
In-Depth Information
Figure 9-4
.
Setting the SortKeyPosition property value in the Advanced Editor for XML
Source
6. Repeat steps 3-5 for the
Customer
output.
7. Click OK to save the changes and return to the designer.
By setting the
SortKeyPosition
value for the
Customer_Id
columns in the
Name
and
Customer
outputs, we've told SSIS that the rows will be sorted. We can
now map both outputs directly to the Merge Join transform (as shown in
Figure 9-5
),
and select the columns we want for our destination table (as shown in
Figure 9-6
)
.
Search WWH ::
Custom Search