remove part of string
Hello ,
I would like remove some part of the string in ssis.
example : the loan has 50+ numbers. i want to remove just + sign from that . how would i do that in ssis.
July 8th, 2011 7:33pm
You can use a
Derived Column Transformation (follow the link for more details) that encompasses the following SSIS Expression with "replace [column] option:
REPLACE(LoanColumn, "+", "")
Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 9th, 2011 12:41am