Re: SQLXMLBulkLoad of text child nodes vs. attributes?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Irwin Dolobowsky [MSFT] (irwind_at_mail.microsoft.com)
Date: 11/01/04 

Date: Mon, 1 Nov 2004 15:48:32 -0800

you can only map simple-type elements to columns. ALso, I would recommend
moving to XSD. 

-- 
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"KW" <newsgroups@weinerk.mailshell.com> wrote in message 
news:f9f22f30.0411010908.78662fc6@posting.google.com...
> SQLXMLBulkLoad of text child nodes vs. attributes?
>
> Given:
> 1) XML something like <e1 a1="aaa" a2="bbb">CDATA[[blah]]</e1>
> 2) using MSSQL 2K with SQLXML 3
> 3) using MS XML View Mapper to make the xdr to load data
> 4) using vbs to oXMLBulkLoad.Execute "C:\XMLData\kw.xdr", 
> "C:\XMLData\tmp.xml"
>
> Question:
> XML element attributes map to SQL schema OK
> but how do I map the XML element child text to a field in SQL record?

Relevant Pages

  • BizTalk 2004 Mapping / Sub Maps??
    ... data from an XML Element and map it to a new XML Document. ... TDT4AUPS ...
    (microsoft.public.biztalk.general)
  • RE: Mapping
    ... As per my understanding I have re-created your scenario in my our test ... lab.Below are the result.You can map the output of map to SQL Schema which ... Output xml File. ...
    (microsoft.public.biztalk.general)