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. Our "XML Extract Task" can be used for sending an HTTP request and receiving a response.
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.
The XML components, part of the SSIS Productivity Pack, will support as many data inputs and outputs as needed.
XML Source & Extract
The XML Source component The SSIS XML Source component lets developers retrieve XML documents from an HTTP URL service endpoint or a local file. It parses the XML structure and outputs column data for downstream SSIS pipeline components. With this component, developers can integrate with virtually any web service by reading XML files or SOAP-based endpoints. It provides maximum flexibility for handling 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.
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. It gives you the flexibility to send a wide range of HTTP requests, including GET, POST, PUT, DELETE, and PATCH, while also providing robust tools for handling the XML data returned.
The component makes it easy to interact with any REST or SOAP API. You can define the request method, add query string parameters and headers, and even configure a request body. On the receiving end, the task processes the XML response, allowing you to extract specific values from the returned data using an XPath query. The extracted values can then be stored in an SSIS variable for use in other parts of your package. This versatility makes the XML Extract Task an ideal tool for automating API calls, integrating with web services, and dynamically fetching data within your ETL workflows.
Premium XML Components
are available within
SSIS Productivity Pack
XML Data Integration Made Easy
Our solution is easy to use, offering code-less integration between the XML data 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.
Our Premium 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 data with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.
See our full product offerings for more information.
More XML/Web Services 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 XML & XML Processing components include:
JSON
