Hi Experts, I have a Source table which has one Column and the values in the Column are Pipe Seperated
I have to split this column into multiple columns and then populate it into a target table.
I have to Split the Column Whereever I find a Pipe symbol. How can I do this using SSIS. Any help or suggestion is highly appreciated.