Hi,

We can generate XML files using for xml clauses in SQLServer.

Step 1: use For xml to get data into XML format.

Step 2: Assign XML data to a object variable using Execute SQL Task.

Step 3: Use a script task to generate XML file using object variable content.

Please refer to below link.

http://www.simple-talk.com/sql/learn-sql-server/the-xml-methods-in-sql-server/

Thanks,

Sambasiva