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...

Hi Naveen,You can create a variable from delivery Properties >> Variable tab >> Add a variable , select the data type and choose if its a static or Expression. If its dynamic, you have to fetch the value via script and pass to the variable you have defined.Regards,Preetham