Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kathunter
Starting Member
35 Posts |
 Posted - 2002-10-14 : 17:10:47
|
| I am unfortunatly stuck with SQL Server 7, and I have to set up a task to import an XML file nightly.I have been researching the different XML techologies, but wondered if anyone has found a "winning combination" for accomplishing this.Thanks,Kat |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-14 : 17:16:56
|
| Write an XSL sheet to translate the XML into a text format that you can import using DTS, bcp, or BULK INSERT. It's pretty easy to do. Then you can create a SQL job with an ActiveX job step that creates an XML DOM object from the XML and apply the XSL to it, and save the converted output to another file.MSDN has loads of examples on the XML DOM methods and how to apply XSL to them. |
 |
|
|
kathunter
Starting Member
35 Posts |
Posted - 2002-10-14 : 19:08:03
|
| Thank you so much! I have been researching for days.KatI should have taken the blue pill |
|
|
|
|
|
|
XML import and SQL Server 7