I have to load XML data into SQL Server through SSIS, In XML Source I am getting some hexadecimal symbols so when I am giving that file as a Source in SSIS it is not accepting that Hexadecimal values, how can I parse or remove those (Hexadecimal Symbols).Error : Character ' ', hexadecimal value 0x2 is illegal in XML documents.Is there any way to remove those using XSLT, If there then please put me in the right way.
Removing hexadecimal values from XML through XSLT
- Thread starter Matt Jo
- Start date