Importing XML into MSSQL 2005 Table

[TiGGi]

Hi all,

I need advice on how to get data from xml file into the preexisting table. Right now I have a process that scrapes data from the website and generates xml file everyday. I need to get this data into sql table every night and I would like to make this automated process. What do I need to use in sql to accomplish this? It would be great if you can point me to a tutorial or give me few pointers.

Thanks!

[chazzy]

I don't think you should be doing this purely on the database. I think you should use C# or another .NET language to pull the file and parse it into the database.

[TiGGi]

hey chazzy, thanx for reply..

I was gonna avoid that thinking that there's better way of doing it using sql. Is there a problem using the sql or just that serverside is better practice?

[chazzy]

It's not what SQL's designed for. SQL lets you look up data in a database or manipulate it once it's in there. There are extensions for handling XML, but the bottom line is that it's going to slow down your database server running it that way.