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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Auto save query to xml

Author  Topic 

ruraldev
Starting Member

2 Posts

Posted - 2007-01-18 : 14:49:04
I have a query which creates xml output for me, at the moment I need to manually save it to a file.

Is there anyway to automatically save the xml output to an xml file when I run the query.

Thanks

Gordon

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-01-19 : 01:38:57
You can use dts or bcp to write to a file...


MohammedU
Go to Top of Page
   

- Advertisement -