The XML SSIS Toolkit provides everything
you need to take any data source and convert it to XML or any other text based file
The XML SSIS Toolkit provides SQL Server Integration Services (SSIS)
tasks and data adpaters on top of the over 80 out of the box SSIS tasks to provide
a complete solution for translating any data source into XML, JSON, CSV, or any
other type of text based file format.
The included tasks will aid in XML mapping, and provide
unique features such as multi level element and attribute support, multiple
encoding format support, and the ability
to preview the XML layout prior to running the SSIS package.