Awesome responses. Thanks a lot.
By the way, I am not very familiar to Powershell and would like to stick to SSIS to generate XML file and to store it in file system.
Could you please let me know what tasks i should be using as i am a beginner to SSIS?
Should i use "Execute SQL task" to run the query that generates XML file and use "File System Task" to save the file in file system?
Thanks again in advance.
Regards,
Suresh