The XML components consists of two components to transform existing XML data into column data, and two other components to transform column data into XML.

With XML components, developers can convert data into XML format or retrieve data from XML format to use in their downstream pipeline.

Now with our 2020 Release Wave 1, we added a new "Key Value Pivot" Output Type in XML Extract/Source component, which can be used to work with key/value pairs values. Additionally, our XML Source component now supports using variables as the source and using @[ResponseStatusCode] token for expression evaluation.

The XML components, part of the SSIS Productivity Pack, will support as many data inputs and outputs as needed.

SSIS XML Components

XML Source/Extract

The SSIS XML Source component allows developers to retrieve XML documents from an HTTP URL based service endpoint or a local file. The components will then break up the structure and produce column data which can be consumed by downstream SSIS pipeline components. With XML Source component developers are able to integrate with virtually any web service by reading from an XML file or a SOAP-based service endpoint. It offers the most flexibility in working with any complex XML documents.

Also available is a XML Extract component which is a transformation component that can be used to extract XML document or column data already in SSIS pipeline by transforming it into tabular data structure which can be further consumed by downstream SSIS pipeline components.

Either component will support as many outputs as needed based on the XML structure to transform all necessary data into column data to use as required in the downstream pipeline.

SSIS XML Source component
SSIS XML Source component - design xml
SSIS XML Extract component

XML Destination/Merge

Using the XML Destination Component, developers are able to merge input data based on the XML data structure defined in the component, and then send the merged XML document to a HTTP URL to perform a SOAP-based service call, or save it as a local file.

Also available is XML Merge component which is a transformation component that can be used within an ETL project to merge input data into XML document structure, and send the document to downstream pipeline components for further processing.

Either component will support as many data inputs as needed to create the desired XML hierarchical structure. The transformed XML data can then be used for many scenarios including sending to a web service, or save to a file stored locally or in the cloud.

SSIS XML Destination component
SSIS XML Destination - Design XML
SSIS XML Destination Output Columns

XML Components: data integration made easy

Our solution is easy to use, offering code-less integration between the XML Components and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of minutes.

XML Components are available within the JSON & XML Processing components of our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate XML Components with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.

See our full product offerings for more information.

Other SSIS JSON & XML Processing Components

Our JSON & XML Processing components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to XML, the JSON & XML Processing components include: