Separation Function in SSIS Expression

Question

I got the column values ​​as "035-7448-001-3854535" In the SSIS data stream, I need to split this into three different components:

**Col1 Col2 Col3** 035 7448-001 3854535 

this can be done using the script component.

Is there a way to handle this in the Derived Column component

thanks

Answer 1

I'm sure you could do this with a combination of FINDSTRING and SUBSTRING , but I think the script component will ultimately produce a more readable, better documented solution.