SSIS: Two ways to export SQL Server database data to an XML file

In SSIS, there is no direct output from the data source to the XML, destination output object has Excel file, Flat file, Database, etc., but does not directly provide the configuration of XML file output.

But we can still do this in the following ways:

Method One: Converting the string XML to output using a flat file

Method Two: Use a Script Task to output an XML string

Test Database-AdventureWorks2012

Test table-[Sales]. [SalesOrderDetail]

Let's say we want to convert the following query results to XML-

A format that needs to be exported as an XML file-