XML Components
via SSIS Productivity Pack
Easily work with XML data in SSIS as if it were column data with the XML Components, found within the SSIS Productivity Pack.
What other applications can you sync with XML?
Click here for more solutions.
Data Integration Made Easy
XML Processing Components
There are five XML Processing components available for working with XML Data: XML Source, Destination, Extract Component, Merge, and Extract Task.
With XML components, developers can convert data into XML format or retrieve data from XML format to use in their downstream pipeline.
The "Key Value Pivot" Output Type in XML Extract/Source component 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.
In our 2023 Release Wave 2, we added the new "XML Extract Task", which can be used for sending an HTTP request and receiving a response.
The XML components, part of the SSIS Productivity Pack, will support as many data inputs and outputs as needed.
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.
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.
New SSIS XML Extract Task
The XML Extract Task is an SSIS control flow task component used for sending an HTTP request and receiving a response. A common use case for this component is downloading a file.
XML Component
is available in the
SSIS Productivity Pack
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 XML & 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 XML/Web Services Components
Our XML & 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 XML & XML Processing components include:
JSON
