question

ayemya avatar image
ayemya asked

XML Task - SSIS

Hi Everyone,

I have multiple xml files. 

<Person><Name>KAY</Name></Person>
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?

Thank you.

Aye

ssisxmlsql xml
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.