Hi alb52547777,Alternatively, you can modify the data in transition
using SQL activity like this,UPDATE <%= vars.tableName %> SET semail =
RIGHT(semail, '10');UPDATE <%= vars.tableName %> SET semail =
concat('61', semail) where length(semail) < 11 ;Where in the first
line->semail is the column name I want to modify the data10 - I'm
keeping last 10 digits in the column, removing anything beyond 10Second
line ->I'm adding 61 at the beginning of the each record where the
record length is less than...