Re: XMLBulkLoad

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks a lot Monica for the reply. Now we are using identity type columns so
solve this (E.g.; D. Bulk loading in identity type columns), we were trying
to create unique identifier in the root element table and carry it to all
the tables. Schema files are very large (aprx. 20 tables in DB). Now with
identity type columns we are using primary/foreign key relationship. Please
let me know if there is a better way to solve this.

Thanks,
SA.
"Monica Frintu [MSFT]" <MonicaFrintuMSFT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:FA2021F2-5DB6-486B-9FF2-4D442AD56F41@xxxxxxxxxxxxxxxx
Hello,

I need more information regarding the tables structure, I cannot infer it
from the xml data.Do you have a schema file as well?

Thanks,
--
Monica Frintu


"Sudheer Aalla" wrote:

Hi All,

Can anyone please explain how can I specify relation between parent and
child table with a unique identifier in sqlxml bulkload (or create unique
identifier and use it as primary key).



<Test>
<Contact>
<Name>RRR</Name>
<Company>SDR Central</Company>
<LastName>SDR</LastName>
<FirstName>Central</FirstName>
<Telephone>(111)-111-1111</Telephone>
<Email>asr@xxxxxxx</Email>
</Contact>
<PP>Web App</PP>
<Date>8/3/2005</Date>
</Test>



Thanks in Advance,
SA


.