SSIS XML Tutorial Part 3 - Using SSIS XML File Destination (Generate XML File in Data Flow)
XML File Destination is very similar to Export XML Task, except that it can use anything from upstream in a Data Flow and then save an XML to a file. XML File Destination, as well as Export XML Task and XML Generator Transform, which I will speak about in a moment, all support multiple data inputs. It means that you can have, for example, Customers as one input, Orders as another, and then join these two on a key to write customers with all their corresponding orders as child elements.
https://zappysys.com/products/ssis-po...
Features:
Create XML file from single or multiple inputs in Data Flow
Create simple or nested XML documents inside DataFlow Task using simple drag and drop approach
Ability to create nested XML from Multiple datasets
Ability to create single XML document for all input records or create one document for each input row from ROOT dataset
Preview XML structure as you change layout on User Interface
Ability to join different type of datasets (e.g. SQL Server, Flat File, Excel) to create parent-child relation for nested XML
Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory