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 |
|
venkat.v
Starting Member
4 Posts |
 Posted - 2009-08-26 : 01:03:42
|
Hi,could somebody plz help me out in changing the pattern ( say SSN number) to 'x'i.e., i need to pass a big sentence which contains SSN number in it.Ex :"Hi my name is richard.My SSN no is 123-45-6789"and it should be changed to "Hi my name is richard.My SSN no is xxx-xx-xxxx"I have done by creating function using Patindex but could somebody help me to do this using SSIS.and especially i need to update a whole column which consists of text mentioned above with the change in the pattern..thanks in advance |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-08-26 : 01:18:57
|
| Duplicate posthttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=131761 |
 |
|
|
|
|
|
chagning a pattern using SSIS