Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Removing HTML tags in SSIS

Posted on 2011-03-02
3
Medium Priority
?
2,094 Views
Last Modified: 2012-05-11
Hi,

I have an nvarchar(max) column in a table in a SQL Server 2008 database that contains html formatted message text. For a report, I have been asked to strip out all html tags so that only the plain text messages are put into the report.

Is there a community custom SSIS task out there that will do the job that anyone knows of? If not, can anyone advise on the best approach to this problem?

Thanks in advance.
0
Comment
Question by:irb56
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 2000 total points
ID: 35016507
0
 

Author Closing Comment

by:irb56
ID: 35150305
Sorry for the delayed response. The solution is a good one. Many thanks!  :-)
0
 
LVL 25

Expert Comment

by:reb73
ID: 35151678
Glad to be of help, cheers!
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question