locked
SSIS on Export convert data to HTML RRS feed

  • Question

  • HI,

    I have a data in a column that contains HTML data. I need to convert them into String.

    For Example:

    I need to convert Qualitätspolitik  -->  qualitätspolitik

    I need to convert Alzheimer’s  --> alzheimer’s

    I need to convert reducirán -->reducirán

    Can i do this with SSIS on export to .txt or .csv converting the data. The above are just examples . I got more of such data.

    Any help would be great.

    Regards,

    PS


    Regards, PS

    Monday, June 24, 2013 2:05 PM

Answers

  • You could use a Script Component to do it:
    Row.YourColumn = System.Net.WebUtility.HtmlDecode(Row.YourColumn);


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    • Proposed as answer by COZYROC Monday, June 24, 2013 7:58 PM
    • Marked as answer by Pritam_Shetty Tuesday, June 25, 2013 9:20 AM
    Monday, June 24, 2013 7:07 PM

All replies

  • It is not a conversion, it is a cleanup exercise, so you can use a file passed to a command line utility as http://www.nirsoft.net/utils/htmlastext.html. It will save a copy in plain text and you are done.

    Arthur My Blog

    Monday, June 24, 2013 2:59 PM
  • You could use a Script Component to do it:
    Row.YourColumn = System.Net.WebUtility.HtmlDecode(Row.YourColumn);


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

    • Proposed as answer by COZYROC Monday, June 24, 2013 7:58 PM
    • Marked as answer by Pritam_Shetty Tuesday, June 25, 2013 9:20 AM
    Monday, June 24, 2013 7:07 PM
  • Hi ,

    Thanks it worked like a charm.

    Row.YourColumn = System.Net.WebUtility.HtmlDecode(Row.YourColumn);

    Moreover for others in details please refer to the below URL on how its done in SSIS. It worked like a charm for me. Thanks a lot.

    http://www.harlansmith.com/2010/07/decoding-html-encoded-text-in-ssis.html

    Regards,

    Pritam


    Regards, PS


    • Edited by Pritam_Shetty Tuesday, June 25, 2013 9:23 AM Added Scripts
    Tuesday, June 25, 2013 9:22 AM