RE: how to import an xml file to sql

Here is a small example:

<Product Id="-av1011-bass">
<Code>AV1011-FS-BASS</Code>
<Description>Bass Industries Avalon [AV1011-FS-BASS]</Description>
<Url>http://www.bizchair.com/-av1011-bass.html</Url>
<Orderable>NO</Orderable>
<Taxable>NO</Taxable>
<Path>
<ProductRef Id="bass-industries"
Url="http://www.bizchair.com/bass-industries.html";>Bass
Industries</ProductRef>
</Path>
<Caption><li>A blend of contemporary edge, softness and
comfort</li><li> A great synergy of design, special relationship and
function</li><li>Life time warranty on frames, springs, and moving
parts</li><li>2 year warranty</li><li><b>Come to BizChair.com for all your
Home Theater Furniture and for all your Home Furniture needs!</b></Caption>
</Product>
<Product Id="-ma1061-bass">
<Code>MA1061-FS-BASS</Code>
<Description>Bass Industries Matinee Lounger
[MA1061-FS-BASS]</Description>
<Url>http://www.bizchair.com/-ma1061-bass.html</Url>
<Orderable>NO</Orderable>
<Taxable>NO</Taxable>
<Path>
<ProductRef Id="bass-industries"
Url="http://www.bizchair.com/bass-industries.html";>Bass
Industries</ProductRef>
</Path>
<Caption><li>Available in Black Leather Only</li><li>Straight Row
Only</li><li>Motorized Recline</li><li>Chaise Styling</li><li>Space
Saver</li><li>Life time warranty on all frames, springs and moving
parts</li><li>5 year warranty on leather</li><li>2 year warranty on all other
materials</li><li><b>Come to BizChair.com for all your Home Theater Furniture
and for all your Home Furniture needs!</b></Caption>
</Product>

For books online do I just look for SSIS?

Thanks
Dee

"ML" wrote:

Have you tried the examples in Books Online?

You could also use SSIS to parse the XML and extract the information you
need, either way - you won't be able to avoid at least a bit of coding.

If you post a sample of the XML (not the whole thing, of course) then we can
help you come up with a more accurate solution.


ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/
.

Relevant Pages

  • Re: SQL/XML Annotation Question - a different take
    ... Struggling with SSIS. ... It does not like the xsd file....but have more ... Looked at some of the bigger XML files, ... Looks like they don't have the annotation/relationship sections at the ...
    (microsoft.public.sqlserver.xml)
  • Re: XML Newbie - T-SQL to XML ??
    ... The first place I started looking was Books Online. ... http://www.sqlxml.org is also an excellent resource ... for both retrieving and using XML in SQL applications. ... For example the header might include ...
    (microsoft.public.sqlserver.xml)
  • URGENT - Using XML Source - Related issues and usage
    ... Using XML Source - Related issues and usage ... Already tried to look for articles on the net and consulted Help inside SSIS ... The job is to get this XML data directly in to a SQL Server database table ...
    (microsoft.public.sqlserver.xml)
  • Re: SQL/XML Annotation Question - a different take
    ... I guess the question you are referring is the SSIS question "how does ssis finds the relationship". ... SQL Server MVP ... Looked at some of the bigger XML files, they look very complicated, meaning multiple tables. ... That is the basis of my question: two different groups, putting out Schema's for people like me and we have to sort through huge xsd files to figure out multiple table relationships...just does not make sense. ...
    (microsoft.public.sqlserver.xml)
  • Re: Xml datasource for the cubes
    ... DAve, thank you for your answer, but as I am a newby on this subject, could ... > You can load XML structured data via SSIS and then SSIS can pump that data ... > not read the XML data; but SSIS can and then hand it off to AS. ... > SQL BI Product Unit ...
    (microsoft.public.sqlserver.olap)
Loading