none
Parsing Illegal XML Character - SSIS RRS feed

  • Question

  • Hi,

    I want to parse the following illegal xml character which is '・�' in the following string using ssis.

    abc_信託勘定元帳・�

    After parsing I should get the following string

    abc_信託勘定元帳

    Any help would be highly appreciated.

    Thanks


    • Edited by Ali_Hum Wednesday, May 29, 2013 10:15 PM
    Wednesday, May 29, 2013 9:42 PM

Answers

  • ・� looks like comprised of two chars ・ and �

    You must be fine using this SSIS expression in Derived Column Transformation:

    REPLACE([Column1],"・�","")


    Arthur My Blog

    Thursday, May 30, 2013 2:09 PM
    Moderator