Press "Enter" to skip to content

Exporting XML Files from SQL Server via Powershell

Vlad Drumea extracts some data:

SSMS doesn’t really have a way to output XML data into files directly, and doing it manually starts to become a pain after the 3rd or 4th file.

You can do it via SSIS, but not everyone has SSIS installed or the time to figure it out.

Admittedly, I’d start with SSIS myself, but it’s good to have multiple ways of solving a problem.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.