Merge the XML file using XML task in SSIS

 With the help of this option we can marge the two xml which have the same structure.

Below are the files.

  

Let’s see how we will merge both files.

Selecting Operation type as Merge

 

And creating the connection.

 

Here we need to provide the root node. In the case of us, Class is the root node.

Now we need to set the operation result.

   

Here we are creating the file connection and saving the merge output in the file.

 

Here we need to provide the information which we want to add.

Keep in mind: we can add only one node at a time. If we have multiple nodes in this case our package will fail.

Now our package is ready to run.

Running my package. 

Package executed successfully.

See the merge file.

  

If we have multiple nodes in that case we can use the script task and add these data.