I have a source table where one of column has data like:
Column SD SD .. .. JK Jk .. ..
I want to load this data into staging in format of:
Column S&D S&D .. .. J&K J&k .. ..
Meaning I want to insert '&' character wherever we have data like
JK, while loading to staging.
I need to convert it for SSIS. So I want to give here SSIS formula to achieve this.
How can we achieve this?