SSIS Productivity Pack is a large collection of premium and unique SSIS components to help make SSIS more powerful and a developer's job easier. The collection contains 4 components to facilitate working with XML from within SSIS.
With an XML Source, Destination and 2 transformation components developers have great flexibility when it comes to working with XML data within SSIS. Also included as an HTTP Connection Manager that supports working with virtually any SOAP or REST endpoint including those with OAuth2 authentication.
SSIS XML Source
The SSIS XML Source component allows developers to retrieve XML documents from an HTTP URL 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 through an XML or SOAP-based service call.
Also available is a XML Extract component which is a transformation component that can be used within an ETL project to extract XML data from various sources.
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 Destination
Using SSIS XML Destination, developers are able to merge input data based on the XML data structure defined in the component. You can then specify the component to write the merged XML document to a local file or you can send it to a HTTP URL to perform an XML or SOAP-based service call.
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.
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.
Works with SSIS 2005 - 2017.