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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-05 : 08:14:38
|
| Ian writes "I am trying to export some data (from one table - simple query) to an xml file. I've tried various suggested workarounds such as creating XML Tags for each field and then exporting the result set, that was a huge file and the result wasn't clear xml so it didn't work.I then tried a SQL stored Procedure called sp_makewebtask and that returned half an xml file but with errors that made no sense as the underlying records were sound. It also suggested this doesn't work to well with large recordsets, soI then tried a DTS package calling a stored proc using an ActiveX object. This failed in trying to create the initial XML document...As a last resort I tried the BCPfunction with queryot specified and that just ran in a continuous loop with no error message and no result set!I found these solutions on the following websitehttp://www.perfectxml.com/Articles/XML/ExportSQLXML.aspMaybe you have some other suggestions...Thanks,Ian" |
|
|
|
|
|
XML extract from SQL Server 2000