Скачать или смотреть SSIS XML Tutorial Part 2 - Using SSIS Export XML File Task (Output SQL Server Data to XML)

Use Export XML Task when you want to export XML from a database with great performance. Export XML Task supports SQL Server or any other database that you can connect to using ODBC or OLEDB drivers. You can export XML to a file, Azure Blob Storage, Amazon S3 Storage, SFTP or FTPS. With Export XML Task you can export a table as is with minimal configuration or export to a custom layout XML.

https://zappysys.com/products/ssis-po...

Features:

Export multiple tables/views to XML files (e.g. Sales% or do SalesJan|SalesFeb)
Export SQL query output to XML file
Inbuilt Layout Editor for creating complex XML with nested structure (Document Array, Value Array, Nested attributes
Automatically Split exported XML data into multiple files by Size or Number of records
Automatically Split exported XML data into multiple files by Split By Column (e.g. SplitBy=Country will create new file for each country)
Support for Compression and Append
Create Multi content XML documents
Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: XML related articles