Results 1 to 2 of 2

Thread: XML question

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Question Unanswered: XML question

    Hi all,

    I'm new to the world of XML and SQL intergration. I want to import a stocklist into a MSSQL table. I want to do this periodically as the XML file is located on a remote server and changes regularly.

    Here is a snippet from the XML file:

    <?xml version="1.0" encoding="UTF-8" ?>
    <STOREITEMS>
    <PRODUCT ITEM="0001">
    <STOCK>In Stock</STOCK>
    </PRODUCT>
    <PRODUCT ITEM="0002">
    <STOCK>In Stock</STOCK>
    </PRODUCT>
    <PRODUCT ITEM="0003">
    <STOCK>In Stock</STOCK>
    </PRODUCT>
    <PRODUCT ITEM="00031">
    <STOCK>In Stock</STOCK>
    </PRODUCT>
    ....<snip>.....
    </STOREITEMS>

    Can anyone point me in the right direction?

  2. #2
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    Have you looked at OPENXML in Books Online yet?
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •