changing pattern using SSIS

• venkat1.v

  Newbie

  Points: 8

  More actions

  August 25, 2009 at 11:17 pm

  #137535

  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:-)

• Joy Smith San

  SSC-Insane

  Points: 24877

  More actions

  August 25, 2009 at 11:42 pm

  #1044683

  Could you pls post the function you have written.?

  Am not clear on the exact requirement.