By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,190 Members | 1,412 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,190 IT Pros & Developers. It's quick & easy.

XSD, complexTypes, SQLXML bulk load: What am I missing?

P: n/a
Hello Techies--

I am reading an XML document with many nested elements. Many of these
elements go to such a variety of tables, that I am trying to simply
the read of the document by dumping the data into a single table using
SQLXML/BulkXMLLoad. I have triggers set on an insert of this table to
cascade inserts to the appropriate myriad of other tables. Originally
I tried to use simpleType, then I tried to use: complexType,
mixed="true" when setting up the schema, but received errors from
SQLXML stating that mixed type cannot be used. The bottom line: For
every level of sequenced elements, I am writing a new row to the same
table. What I want is a single row going to a single table--with all
the complex elements in place. I am sure that I am missing something
important regarding single tables/complexTypes and sequences. Please
review the XML output that I'm reading and the schema snippet with
it-- in order to give me some direction--as I've reached an impasse.

Any help will be greatly appreciated.

Thanks,
Paula DiTallo

------------------- Snippet of XML output --------------------------
<X12_4010_837>
<X12_EnvelopeHeader>
<ISA_InterchangeControlHeader>
<ISA01__AuthorizationInformationQualifier>00</ISA01__AuthorizationInformationQualifier>
<ISA02__AuthorizationInformation>1234567890</ISA02__AuthorizationInformation>
Nov 11 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.