Extracting part of a string in ssis RRS feed

  • Question

  • hello folks,

    i have a column i trying to load into destination but not sure how to do it in ssis.

    the data is like this below


    <div class="ExternalClassDB075A28F1AB44DA882ED25EFAA3FD94">Take trial testimony &amp; attempt to settle up to 175k</div>

    just want to only extract 'Take trial testimony &amp; attempt to settle up to 175k' and load it to destination.

    Monday, September 21, 2020 3:05 PM

All replies

  • Do you want to use an SQL statement or a C# code?

    Monday, September 21, 2020 6:35 PM
  • I think as of now using sql stmt
    Monday, September 21, 2020 8:16 PM
  • Hi remo5222,

    Thanks for your feedback.

    Since your question is more related to ssis, it will be more appropriate to ask your question in ssis(Q&A) forum.

    Thank you for your understanding.

    Best Regards,

    Xingyu Zhao

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, September 22, 2020 6:04 AM