Re: How does the "LOAD from_field" work with xml format ?
The fact is that I don't load one "physical" xml file : I load a datasource with several rows and fields, and one of this fields contains an xml structure (the same structure for each row of my datasource). Tell me if you can't open the csv file I attached on my first post, it will clarify all that.
However, just to answer to your question, if I make a physical xml file from one of the record of my datasource, I got something like that (see the sample.xml attachment)
<?xml version="1.0" encoding="UTF-8"?> <notes>
And if I use the wizard to load this sample, I've got :
// Start of [sample.xml] LOAD statements
FROM [sample.xml] (XmlSimple, Table is [notes]);
// End of [sample.xml] LOAD statements
which is exactly the code I used, except i use "From_Field" instead of "From [sample.xml]"