How to generate a xml doc using from database using T-sql

Hi Pankaj,

We can use SSIS to export XML columns from SQL to file, there is an example on the following link, you can refer to it:

Exporting XML columns from SQL to file in SSIS

http://blogs.msdn.com/b/joscot/archive/2012/06/01/exporting-xml-columns-from-sql-to-file-in-ssis.aspx

---

Allen Li

TechNet Community Support