locked
Parsing Illegal XML Character - SSIS RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    ・� looks like comprised of two chars ・ and �

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

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

    Arthur My Blog

    • Proposed as answer by Mike Yin Monday, June 3, 2013 6:29 AM
    • Marked as answer by Mike Yin Sunday, June 9, 2013 4:21 PM
    Thursday, May 30, 2013 2:09 PM