I am trying to read from a xml file and load the data into SQL Server.
My job design is as follows.
External Source Stage -> XML Input Stage -> Transformer -> ODBC
Here, the problem is the data in table is entered along with the XML Tags
![Sad :(](./images/smilies/icon_sad.gif)
Eg: <Name>Meena</Name>
<DOB> 21121986 </DOB>
In the target table columns are Name, and DOB. The data entered looks like
Name, DOB
<Name>Meena</Name>, <DOB> 21121986 </DOB>
Please help on how to remove the tags in the target data
Thanks