XML Import into SQL 2000

  • InvisibleCat

    Default port

    Points: 1496

    Hi,

    I was wondering if anyone could help me out, i'm trying to import an XML file into SQL Server 2000, i'm relatively new to XML but i've manage to get it importing an elements data from a file, no problems so far, however the XML document is made up of multiple elements (Asset, Debits and Amounts) - See attachments.

    I have no trouble importing the actual data from the asset element by creating a mapping xml file (see attachment).

    My problem arises, becuase I need to import the data from the debits element, it seems that I can either do the asset or debits element but not both. Oh i'm using the SQLXMLBulkLoad functionality through an activeX control in DTS. Sorry for posting this in the wrong location as well.

    Any idea's?

  • sameers.khare

    SSC Rookie

    Points: 36

    you need to use open XML commands in sql server 2000, it's simple as sql server doesn't support direct import of XML

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply