XML Import into SQL 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Globalization » XML Import into SQL 2000

XML Import into SQL 2000

Rate Topic

Display Mode

Topic Options

Author

Message

Nic-306421

Posted Thursday, December 13, 2007 4:37 AM

Valued Member

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:31 AM
Points: 58, Visits: 540

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?