Solved

Removing HTML tags in SSIS

Posted on 2011-03-02
3
1,949 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 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Columnstore Indexes - real-time operational analytics 1 35
Sql query 107 63
SSRS Subscription jobs disabled, yet still running 4 36
Webservices in T-SQL 3 31
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article I will describe the Detach & Attach 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.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

777 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