Exporting an XML record to a file

Alyanto
Alyanto used Ask the Experts™
on
I am looking for the best way to export a record in a table that has been saved as XML.  I have available to me SSIS.  What would be the best way to do this?  Any pointers to webpages or articles would also be very helpful to me.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
It is an export from XML to a file.
Top Expert 2012
Commented:
If it is really and Xml document saved in a column, then it should be as simple as creating an export package with a query like this:
SELECT YourXmlColumn
FROM YourTable
WHERE <add your condition here>

Author

Commented:
Hi Anthony
Many thanks for this simple and effective solution.

/Aly

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial