SQLXML Bulkload multiple rows with parent node reference



How do you specify the annotated XSD for the following XML:

<Portfolio>
<AccountNumber>1234</AccountNumber>
<Securities>
<Symbol>IBM</Symbol>
<Symbol>AAPL</Symbol>
<Symbol>DELL</Symbol>
</Securities>
</Portfolio>

I would like the table to contain:

1234 IBM
1234 AAPL
1234 DELL

Howerver, the annotated XSD schema I came up with give me an error:
Data mapping to column 'Symbol' was already found in the data. Make
sure that no two schema definitions map to the same column.

In this case, how do you reference the parent AccountNumber for each
instance of the Symbol?

.


Loading