XML SSIS Toolkit

Transform any data into text based formats such as XML and JSON

XML SSIS Toolkit Overview

The XML SSIS Toolkit allows you to map any SQL Server Integration Services (SSIS) data to XML using three data flow components: Template Transformation, XML Merge Transformation, and XML Formatter.

The Template Transformation component is the primary component for generating XML documents. From that one component you can generate any XML based documents as well as non-XML based documents quickly and easily.

In addition to the data flow components there is also the String Concatenation Task, and File Load Tasks to make quick work of any XML data mapping/conversions you may encounter.

Text Transformation Tools

Text templating to create any type of XML or flat file data

More Tools for your Toolbox

The XML SSIS Toolkit provides several SSIS tasks and data adapters on top of the over 80 out of the box SSIS tasks and data adapters to bring a complete solution for integrating from a variety of data sources such as Web services, XML, OLE DB data sources, ODBC, flat files, and Excel.

No Code

Most integrations can be done without coding. However the SSIS foundation provides for the ability to completely customize all aspects of the integration using the .NET programming language at any step in your integrations for the most powerful and compact Dynamics GP integration tool on the market.

SQL Server Compatibility

All Keelio Software products are compatible with all editions of Microsoft SQL Server 2005 and above (32-bit and 64-bit).

Flexible Licensing

Licensing terms and conditions can be found by viewing the licensing page.

XML Depth and member tooltips and syntax auto completion using eConnect XSD files.
IntelliPrompt auto completion and member expansion.
Define columns that will be transformed to XML with flexible escaping options.
Ability to automatically filter out invalid XML data, handle white space, and define escape profiles.
Enable or disable IntelliPrompt syntax auto completion and define header and footer text fragments.
Provides one-to-one and one-to-many relationship mapping.


The following features are included in the XML SSIS Toolkit

  • Text templating to create any type of XML or flat file data
  • IntelliPrompt / IntelliSense editor that allows for intelligent XML creation using eConnect XSD file definitions, automatic code completion, node tooltips, and XML highlighting.
  • Ability to save directly to file system
  • Ability to save text to string variable
  • Multi-Level element and attribute mapping
  • All encoding formats supported
  • Preview window to see how your XML will look before executing the SSIS package
  • Binary data automatically gets converted to Base64 or hexidecimal
  • Primary key change detection
  • XML Formatter pipeline component (Remove Indents, Add Indents, Change encoding formats)
  • XML Merge transformation with primary key change detection

Included Products

The following SSIS components are included in this toolkit

  • File Task
  • Template Transformation
  • XML Formatter Transformation
  • XML Merge Transformation
  • Sample Integrations

Ready to purchase?