Hi Guys,
If you want to remove first few characters in a word in one of the column in derived column in ssis then you can use the below statement
REPLACE (<columnname>,"Word to be replaced","")
Example - SUPER_CLIENT in column PORTFOLIO will be replaced by nothing or that word will be removed using the below statement
REPLACE(PORTFOLIO, "SUPER_CLIENT:","")
If you want to remove first few characters in a word in one of the column in derived column in ssis then you can use the below statement
REPLACE (<columnname>,"Word to be replaced","")
Example - SUPER_CLIENT in column PORTFOLIO will be replaced by nothing or that word will be removed using the below statement
REPLACE(PORTFOLIO, "SUPER_CLIENT:","")
No comments:
Post a Comment