I have multiple xml files.
I want to add a root tag and my xml files look like <Root><Person><Name>KAY</Name></Person></Root>
I am looking for an automated way that I can add to my SSIS package to add root tag in all of the XML files. Can I use XML Task? Any recommendation. I am not familier with XML Task? Will you please give me some direction to go?