export from sql server to xml file
Is there a way to export data in xml file from sql server table using SSIS?SandyLeo
October 28th, 2010 6:06pm
Just to confirm, you want to export XML data stored in a table to a file, right?
If yes, you can do this in Execute SQL Task
SELECT
* FROM MyTable
FOR XML AUTO
and pass that to a Flat File Connection
Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
October 28th, 2010 8:26pm