How do I import a physical file with XML-data into MS-SQL?

[fvlo]

I want to import data coming from another system into my SQL-database.
This data is in XML-format in a physical file and this file can be very big.

I have searched the internet and MSDN but cannot find a way to do that from within a SQL-procedure.

Can anyone tell me how I should do this or where to find the info needed?

 

[mbeth6]

I am having the same issue and would appreciate help here as well.

Thank you in advance.

 

[vongrunt]

Quite possible with sp_xml_preparedocument and OPENXML clause... but that's just the top of an iceberg

 

[mbeth6]

Thanks for your timely reply. I did try that, and you are so right just the tip...

I was able to do it through VBScript and ADO.

 

[SqlHunter]

mbeth6 can u please show us how its done..I have also the same issue

 

[HamotIntern]

I too am having problems using OPENXML with a XML file. Perhaps by replying to this, the thread will surface to the top again and perhaps someone who understands OPENXML will help us.