The XML SSIS Toolkit provides everything you need to take any data source and convert it to XML or any other text based file format.
The XML SSIS Toolkit provides SQL Server Integration Services (SSIS) tasks and data adapters 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, several different encoding formats support such as UTF-7, UTF-8, UTF-16, UTF-32, and ASCII, and the ability to preview the XML layout prior to running the SSIS package. More Info>>
