The XML Output Destination is a flexible component for SSIS designed to output your data from one or many files into an XML file. You can properly format the file easily using an XSD file to your company's specifications.
Feature highlights:
The XML Generator Transform can take data from an SSIS data stream and convert it into an XML representation. Since this component is a transform, you can output the data to any destination. It can also take data from one or more data inputs.
Feature highlights:
Task Factory
60+ high-performing SSIS components
Save time managing tedious data warehousing ETL tasks
Connect to dozens of data sources