krzysiek m.

I have a query that generates xml:
SELECT id, Name
FROM Table
ORDER BY 1
FOR XML RAW


It returns a single row with one column:
XML_F52E2B61-18A1-11d1-B105-00805F49916B
<row ID="1" Name="A"/><row ID="2" Name="B"/><row ID="3" Name="C"/>


But when I try to use a DTS that using this query outputs the result to a
text file (as xml),
contents of the file is odd...something like:
4414690064005F00450071007500690070006D0065006E0074 00430061007400650067006F00
7200790044044E0061006D006500440372006F007700010302 014201000000020210E2040000
07004B6F6D666F727443010302014202000000020210E20400 000E0042657A706965637A65F1
7374776F43010302014203000000020210E20400000700446F 6461746B6943

How to output the result of the query to a text file by DTS...please?

Krzysztof

bryant likes

See:
http://sqlxml.org/faqs.aspx?faq=10

--
Bryant