Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sweatha
Starting Member
1 Post |
 Posted - 2010-10-20 : 11:30:07
|
| Hi All,I have a Task where i will be getting a file on dailybasis in that i have a column called "Notes"before loading that file into our DB i have to check wether there are any SQL Scripts or HTML tags in that particular column called NOTESso that it wont effect our DB like(SQLINJECTION),the column NOTES is of Datatype Varchar(5000),FYI that column has text about the customer and Agent discussion in less than 5000 wordsso can some one suugest me how to create an SSIS package or write a SQl query to Filter those HTML and SQL SCRIPTS in that particular Column.Thanks in Advance |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-20 : 12:31:17
|
| Kristen posted a solution here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=148522 |
 |
|
|
|
|
|
find HTML tags,sql script in a column of varcha