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.
Table 9-1 . Column Data Ttype Mapping for the XML Sample
 
 
 
 
 
Search WWH ::




Custom Search