December 13, 2007 at 4:37 am
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?
February 12, 2010 at 11:13 pm
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply