how to read the xml data from sql server

Question

Viewing 5 posts - 1 through 4 (of 4 total)

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

Adiga One Orange Chip Points: 27284 More actions · Answer 1

There are various methods of doing this. One of them is explained in this KB

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

Ankam Valued Member Points: 65 More actions · Answer 2

i have a xml file at c:\sample.xml

i want to read the sample.xml file from my stored procedure how can i?

liebesiech SSCrazy Points: 2610 More actions · Answer 3

Check what Adiga is writing! The KB article explains it very nicely. Here again the link: http://support.microsoft.com/kb/316005

The input XML files (data and mapping) are referenced in the second last line: objBL.Execute "c:\customermapping.xml", "c:\customers.xml"

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")

objBL.ConnectionString = "provider=SQLOLEDB.1;data source=MySQLServer;database=MyDatabase;uid=MyAccount;pwd=MyPassword"

objBL.ErrorLogFile = "c:\error.log"

objBL.Execute "c:\customermapping.xml", "c:\customers.xml"

Set objBL = Nothing

Hope this helps.

BrainDonor SSCoach Points: 19254 More actions · Answer 4

Hi Shiva,

If you want to import an XML file purely via T-SQL, have a look at these examples:

which explains how to import the XML data from a file into a table for further extraction

and:

which shows a basic example of how extract individual fields from the XML column data.

Steve Hall
Linkedin
Blog Site