XML Patterns - SQL Server Integration Services Design Patterns - page 260

as a primary key for the row. Outputs generated for child elements will contain an _Id
column for their parent element's output, which allows the data to be joined later in
your data flow if needed.
Figure 9-1 shows the outputs and column names generated by the XML Source
component for the XML document in Listing 9-3 .
Figure 9-1 . Outputs and columns generated for the Name element