Results 1 to 2 of 2

Thread: XML question

  1. #1
    Join Date
    Jun 2004

    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" ?>
    <PRODUCT ITEM="0001">
    <STOCK>In Stock</STOCK>
    <PRODUCT ITEM="0002">
    <STOCK>In Stock</STOCK>
    <PRODUCT ITEM="0003">
    <STOCK>In Stock</STOCK>
    <PRODUCT ITEM="00031">
    <STOCK>In Stock</STOCK>

    Can anyone point me in the right direction?

  2. #2
    Join Date
    Apr 2004
    Kansas City, MO
    Have you looked at OPENXML in Books Online yet?
    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