An alternative:

http://sqlxml.org/faqs.aspx?faq=10
http://msdn.microsoft.com/library/de...ma-mz_2p0r.asp
http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=9336


John

"Matt Douhan" <matt@fruitsalad.org> wrote in message
news:vi8421-q82.ln1@minihopp.internal.hasta.se...
> hello
>
> I have an application where i need to export XML files and put them on a
> server share as XML files.
>
> How can I achieve the XML export part? making the query and such is easy
and
> exporting as CSV and using BCP is ok, but I really would need to export as
> XML files instead of CSV.
>
> Any ideas?
> --
> Matt Douhan
> www.fruitsalad.org
> matt@fruitsalad.org
> *** ping elvis ***
> *** elvis is alive ***