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

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>
      .
      .
      .
   </ISA_InterchangeControlHeader>
   <GS_FunctionalGroupHeader>
       <GS01__FunctionalIdentifierCode>HC</GS01__FunctionalIdentifierCode>
       <GS02__ApplicationSendersCode>00001</GS02__ApplicationSendersCode>
   <GS03__ApplicationReceiversCode>00004</GS03__ApplicationReceiversCode>
     .
     .
     .

  </GS_FunctionalGroupHeader>
  <ST_TransactionSetHeader>
   <ST01__TransactionSetIdentifierCode>837</ST01__TransactionSetIdentifierCode>
   <ST02__TransactionSetControlNumber>3456</ST02__TransactionSetControlNumber>
  </ST_TransactionSetHeader>
  </X12_EnvelopeHeader>
   <BHT_BeginningOfHierarchicalTransaction>
       <BHT01__HierarchicalStructureCode>0019</BHT01__HierarchicalStructureCode>
       <BHT02__TransactionSetPurposeCode>00</BHT02__TransactionSetPurposeCode>
      <BHT04__TransactionSetCreationDate>10/15/98</BHT04__TransactionSetCreationDate>
     .
     .
  </BHT_BeginningOfHierarchicalTransaction>
  <REF_TransmissionTypeIdentification> 
    <REF01__ReferenceIdentificationQualifier>87</REF01__ReferenceIdentificationQualifier>
    <REF02__TransmissionTypeCode>004010X098</REF02__TransmissionTypeCode>
    </REF_TransmissionTypeIdentification>
<Submitter_1000A>
  <NM1_SubmitterName> 
      <NM101__EntityIdentifierCode>41</NM101__EntityIdentifierCode>
      <NM102__EntityTypeQualifier>2</NM102__EntityTypeQualifier>
       .
       .
 </NM1_SubmitterName>
</Submitter_1000A>
<Receiver_1000B>
  .
  .
  
</Reciever_1000B>
</X12_4010_837>

-------------------- Snippet of XSD Schema
-----------------------------

<xsd:element name="X12_4010_837" sql:relation="zzz_HoldingTIPS_837" >
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element name="X12_EnvelopeHeader"
                    sql:relation="zzz_HoldingTIPS_837" 
        	    sql:relationship="Dump837Elements">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="ISA_InterchangeControlHeader"
                    sql:relation="zzz_HoldingTIPS_837" 
        			sql:relationship="Dump837Elements" >
                <xsd:complexType>
                  <xsd:sequence>
       				<xsd:element
name="ISA01__AuthorizationInformationQualifier" type="xsd:string" />
					<xsd:element name="ISA02__AuthorizationInformation"
		type="xsd:string" />

------------------------end of snippet-------------------------
0
plditallo (1)
8/29/2003 8:24:11 PM
dotnet.xml 7266 articles. 0 followers. Follow

0 Replies
1125 Views

Similar Articles

[PageSpeed] 56

Reply:

Similar Artilces:

Missing Lucida Handwriting Font
Recently reformatted. Inst. Win XP Home, Of.2000 Prof. Had previously used Lucida Handwriting on Business Cards.but now cant find. Went to Discussion group for Office, Graham ind. would find in Pub.2000. Looked in Fonts Folder. not there either. Any other suggestions, short of upgrading to 2003. Troi, Puerto Rico According to http://www.microsoft.com/typography/fonts/font.aspx?FID=55&FNAME=Lucida+Handwriting+Italic&FVER=1.67 that font is part of MANY Microsoft products. I did a quick Google search and found http://www.1001fonts.com/payfonts/794/Lucida-Handwriting.html -- JoA...

Extension 'SMTP' could not be loaded #3
Hi everyone, this morning when I tried to open IMS, the following error appeared: ========================================================================================== Extenstion 'SMTP' could not be loaded. A problem occurred with the extension .DLL file, possibly due to memory shortage. Close some applications or windows, and try again. Microsoft Exchange Administrator ID no: c10312c6 =========================================================================================== Everything was working fine on Friday. We have Exchange Server 5.5 (SP4) running on Windows NT...

Missing links
Could someone please help me with 'Links'. When I open my Workbook I'm asked to identify the location of another Workbook that my Workbook is kinked to. This other Workbook no longer exists and I know for a fact that I don't need any links to it. I've looked everywhere in my Workbook but can't see the links anywhere. If I can't find the cells in my Workbook that are looking for data in the other Workbook, then I can't remove the links. I have looked EVERYWHERE in my workbook, (there are no hidden Worksheets.) Please help! RG Hi Richard maybe the following...

server folder missing unde first afministrative group
Hi, I have a customer whose office mgr was looking around in ESM and now the server folder under First Administrative Group is missing. How can we bring it back? Exchange still seems to be running, however. Thanks, Joseph Right-Click The org in the ESM/Properties and check the "Display Administrative Groups" checkbox. On Wed, 2 Mar 2005 09:19:04 -0800, "j007w" <j007w@discussions.microsoft.com> wrote: >Hi, > >I have a customer whose office mgr was looking around in ESM and now the >server folder under First Administrative Group is missing. How can...

Loading Outlook 98 over OL2000?
I was on OL98 and installed OL2000. I'm having some conflicts on my system with it. Can I uninstall OL2000 and reload OL98, and still keep my files in Outlook? Or would I loose all my current emails and files? Lori Manning <anonymous@discussions.microsoft.com> wrote: > I was on OL98 and installed OL2000. I'm having > some conflicts on my system with it. Can I uninstall > OL2000 and reload OL98, and still keep my files > in Outlook? Or would I loose all my current emails > and files? Your PST is where your data for Outlook is kept and the PST for those two ...

Annual budget report missing budgeted amounts for categories with scheduled bills
Some time ago Ian Lee had posted a message titled "Marking bills paid". He had very insightfully found that using skip in the scheduled bills and deposits function makes money skip the budgeted amount for the month also! This bad bug causes budget reports for the month to show no money as being budgeted for the categories contained within that bill. Here is Ian's original post: http://groups.google.com/group/microsoft.public.money/browse_thread/thread/94da5e0c63b99eb/e506e3b8e2d1820a?lnk=gst&q=budget+bills+2006+skip#e506e3b8e2d1820a The workaround solution as described by Ia...

Program missing on my computer
I had to make room on my computer to be able to install Turbo Tax (I still have only a 166 system) so I deleted Access and Excel which I don't use at home anymore. Apparently I also deleted a file I need to open Turbo Tax Federal and State. It is a dll file. How do I return this to my harddrive since I do not know where it came from to begin with. I no longer have the CD that I programmed the computer with awhile back. What options do I have. Does anyone out there know? Try reinstalling Turbo Tax? -- Joe Norton "Anita" <anonymous@discussions.microsoft.com&g...

XSD
Where can I find the .xsd for the "Save As" XML Spreadsheet option. I am building out my own xml and need to validate it before I send it to excel. I've searched msdn, google, and all the common locations to no avail. If there is another means of validation(Aside from opening the file in Excel), please let me know. Thanks ...

web access not loading
Hi Using Outlook web access, all of a sudden it won't display the messages just the loading caption. Server side settings OK and my IE 6.1 settings show 128 bit encryption cipher. only happens on my own home PC was fine on it a few weeks back. Any ideas out there what may be causing it? thanks "Wendy Bowler" <thebowlers@tesco.net> wrote in news:9_r%b.38$44.37@newsfe1-win: > Using Outlook web access, all of a sudden it won't display the > messages just the loading caption. Server side settings OK and my IE > 6.1 settings show 128 bit encryption cipher. ...

How can I prevent Money from automatically loading previously downloaded statements for reconciliation?
I am using Money Standard 2000. I have always downloaded my bank statements via the web and then, when I have chosen to do so, imported the downloaded statements into Money for reconciliation. That way, I can wait to import the statements until after I have hand entered the transactions for a particular period, which is what I prefer. I recently bought a new computer and installed Money. I had not entered data into Money since last April, although I had downloaded ..ofc statements from my bank at regular intervals. When I opened Money today, it immediately opened my most recently download...

Missing general ledger entries
We are posting to the general ledger from other modules. Occassionally our subsidiaries are out of balance with the general ledger. I find transactions that were posted in sales or purchasing that are not posted to the general ledger. I think someone may be deleting entries from the general ledger before they are posted. I can determine whether a particular transaction from a module is posted to the general ledger, but I am having trouble going the other way. If I find a missing journal entry number is there any way to find out what audit trail code was in that journal entry? We h...

Pages loading without being prompted
Using WinXP Home and Firefox 3.5.5. I have a screen saver that comes on when the computer is idle. I do not turn the computer off at any time. When I roll the mouse to cancel the screen saver often I find the that the start page or some other page has already loaded with no prompt. I delete them and go on to use the computer but find the same thing happening too often. How can I stop this from occurring? Thanks Start by thoroughly scanning for and removing malware. --- Leonard Grey Errare humanum est John Barton wrote: > Using WinXP Home and Firefox 3.5.5. I have a ...

Close button missing
the close button (red cross) is missing from opened emails. I can only close them by going to file and then clicking on close. I tried to customise the menu bar but the close button is not being offered there either. It only applies to opened emails - the Mail Live main site has a close button Anyone got any suggestions? much appreciated -- philbie Do you see Sign in, Minimize or Maximize buttons? -- Ron Sommer MS MVP- Windows Live Mail "philbie" <philbie@discussions.microsoft.com> wrote in message news:161C6334-000D-4314-A518-5527A30F4C7F@microsoft.com... ...

bulk mail
Hi all This is probably a dumb question - is there a quick way to bulk-mail from a CSV or normal-type mailmerge dataset? Any advice gratefully received Jimbo Yes, use Tools | Mail Merge in Word. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Jim McDonald" <jim@missile.demon.co.uk> wrote in message news:cmvrc5$8cp$1$8302bc10@news.demon.co.uk... > Hi all > This is probably a dumb question - is there a quick way to bulk-mail from...

Missing Dates
Hi all I have a table called tblCalendar which just has one field called [CalDate], it has a record for every work day (Mon-Frid) between a Start and End Date (run via code). I have a query called [qry Itinerary Dates Check] which lists all Activity records between the same Start and End Date, the columns of interest are: [ReviewDate] and [Specialist]. What I now want to do is check that EACH specialist has a date in the query for ALL dates in tblCalendar. I want to view any Specialist and Dates that are 'missing', if there are any. I found a similar forum thread an...

Outlook calendar entries missing
I've got some users who create a meeting in Outlook 2003 with invitees but when they send it or update it then send the updates the meeting gets deleted from both the sender and receivers. This only appears to happen when the meeting is created in Outlook 2003 but the meeting is getting deleted from both Outlook 2000 and 2003 users. This is with Office 2003 pre-SP1. Has anybody seen this before or know a possible fix? I've looked through the 2003 SP1 documentation and don't see any reference to this. ...

bulk insert a csv file into a Sql 2005 table
I have a csv file called test.csv located in c:\test folder I need to transfer all data into a table call Testtable In the csv file, there are fields can be with nulll value. The column delimator is " Thanks, qjlee (qjlee@discussions.microsoft.com) writes: > I have a csv file called test.csv located in c:\test folder > I need to transfer all data into a table call Testtable > > In the csv file, there are fields can be with nulll value. > > The column delimator is " So the data look like this: first field"second field"third fi...

DNS and DHCP Servers Suddenly Missing
Hello All, I have two separate SBS 2003 Servers in two locations. One suddenly is missing it's DNS Server which was set up (no longer there, nor in the management options). The other basically had it's DHCP information wiped out. Am wondering what might be happening - is there a virus of some sort targeting these systems? All advice welcome. Companies are unrelated. Thanks. I've never seen the DNS go away but on the DHCP Has someone accidentally Turn on DHCP on the Firewall? Normally this doesn't delete the DHCP However The good news is that you ca...

Running Vista business. Mail merge command is missing.
The Mail Merge command is missing from my Tools drop down in Outlook 2007. I have tried to reste all the Toolbars but did not help. Do you have Outlook installed as part of an Office suite? -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:dailytips-subscribe-request@lists.outlooktips.net EMO - a weekly newsletter about Outlook and Exchange: mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM Do you sync your mailbox with a smartphone or pda...

Outlook Slow Load
I'm running WIN XP & Outlook XP. When I used to run Outlook, it would pop up almost instantly. Now it takes over 2 minutes for the hour-glass to disappear. I have a tiny start-up list and this happens even before I run any other application. Any thoughts on what might make it take so long and what might fix it? Tools | Options | Other | turn off instant messaging integration. -- PATRICK REED [Outlook - MVP]~~~~~~ -Microsoft Certified Professional (MCP) -Have you checked http://www.slipstick.com? -Please post your Outlook version! "Len" <anonymous@discuss...

Invoice random load problem: Operation failed due to a SQL integrity violation
Hi I'm writing a web service to load inside the CRM application a list of invoices. The first time I load the list (about 5.000 invoices) I've no problem. Cause I'm in developing the procedure, after deleting all the loaded invoices, I try to load all of them again.... (of course there can be a lot of reasons to delete a list and load it again....) And now, after about 2000 of succesfully invoice load, I've this error message: 0x80040237 Operation failed due to a SQL integrity violation. Platform If I try the operation again I've the same error, and I can't load an...

Task Manager won't load.
Task Manager (XP Home Edition) won't run by any of the following methods: Right-clicking the Task Bar Ctrl-Alt-Del Ctrl-Alt-Esc Double-clicking on the file itself (taskmgr.exe) in the system32 folder. There are no symptoms at all when any of these methods are used. Nothing runs at all - no windows - nada. However, when I drag a copy of taskmgr.exe to the desktop and double-click on it, I get the following error message: "Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item." I am logged ...

Missing Payees
Anyone ever have a problem with missing payees? I notice this in auto completes. When I start to type the name of a payee I've used for years, it no longer auto-completes. So I go to the list of payees and the one I'm using no longer shows. I can go back and find other transactions (even in the same account) with the payee name. I can even right click and "go to payee..." and make changes, but the payee never shows up in the list. If I just manually type in the same payee name, Money seems to add a new payee with the same name, but the old transactions with the...

XslCompiledTransform.Load() fails sometimes
Basically the issue is, when the XSL style sheet is loaded by URI it is cool but when the exact same style sheet loaded by it's contents the load fails (for this particular style sheet). Because our sheets are kept in a DB, loading by content is preferable. Content based load code: Stream xslStream =3D new MemoryStream(xslString); XmlReader xslTextReader =3D XmlReader.Create(xslStream); compliedXsl.Load(xslTextReader); URI based load code: compliedXsl.Load(xslUri); The error states that there in an invalid character for the encoding at line 2140 position 365. Here is the problematic...

msExchDoFullReplication attribute missing
msExchDoFullReplication attribue is missing in ADSI Edit. Ran Exchange Best Practices Analyser Tool and one of the issues was RUS full rebuild and online advised to change this attribute but the attribute does not exist. Any help? Hi Paul, Right clicking on the relevant Recipient Update Service (RUS) and slecting Rebuild, has the same affect as setting this attirbute with ADSIEdit. I would suggest trying the Rebuild option from ESM and then see if the attribute is created. Regards -- Ben Hoffman MCP (Win2000 Pro/Server & Exchange 2003 Admin) http://www.ExchangeIS.com "Dr. P...