How to use Merge in XML Task SSIS 2014

The XML Task is used when you need to validate, modify, extract, or even create files in an XML format.

In SSIS 2014, there are six operation types are available.

.

Merge: This option allows for the merging of two XML documents with the same structure. You might use this option to combine the results of two extracts from disparate systems into one document

In this example, I use the following two XML file as shown below. Note that you need to exclude the <?xml version="1.0"?> declaration

XPathStringSource property assigned /catalog value

Set the input and output values and XPath string and run.

You can see the merge output file as shown below.

Cheers!
Uma