Dealing with special characters in SSIS RRS feed

  • Question

  • Hi,

        I am developing a package for a simple Text file to Table load with some lookups and updates involved.

    The issue is the source Text files have some special characters. I have attached how the special character looks in the text file and after loading into the table.

    Can you guys tell me is there anyway to remove them in SQL or SSIS?


    • Edited by Manesar Wednesday, December 4, 2013 3:04 PM edit
    Wednesday, December 4, 2013 3:00 PM


  • Check this


    • Proposed as answer by Mike Yin Friday, December 6, 2013 3:10 PM
    • Marked as answer by Mike Yin Thursday, December 12, 2013 2:25 PM
    Wednesday, December 4, 2013 3:01 PM