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.

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.