I thought of using script component but the dataset I'm working with has a lot of columns so if there's a way to to edit or create new column without need to recreate entire
dataset in a script would prefer that
Also, cannot use expression of substring and string manipulation to do this in a derived column since XML column
is of type DT_NTEXT and those functions dont support that data type
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.