Hi,

You can create a task and do select statement of the records you would like and use XML path to create the XML. If you want to create a .xml file of the result you could convert the result to a varbinary(max). We use a similair task and save the varbinary to a new record in a table that holds exported files so the user can download the file from the application. Alternatively, you could probably save the file on a storage location.

Hope this helps!

Marvin

Hi Marvin, 

I have tested this with some dummy code and does work! Thank you!
Although the automatic download is not achievable (as far as I tried), but I can at least generate a .xml file.