Database Reference
In-Depth Information
4. Select Source from the Select Script Component Type dialog as
shown in
Figure 9-9
.
Figure 9-9
.
Creating a new script component source
5. Double-click the component to bring up the Script Transform editor.
6. Click the Inputs and Outputs page.
7. Rename your output from Output 0 to something more meaningful.
Since our sample XML is outputting a set of Customers, that is the
name we'll use for this example.
8. Define the columns as you'd like them to be output. Make sure the
data types for the columns match what has been defined in your
schema.
Table 9-1
shows the column-to-data-type mappings you
would use for the sample defined in
Listing 9-3
.
Your column defini-
tion should look similar to
Figure 9-10
when you are done.
Search WWH ::
Custom Search