• Sounds more like you need a few derived columns rather than a conditional spit. You could then take the parts of the string that you need using the SUBSTRING and FINDSTRING commands in SSIS.

    An example is here:

    http://stackoverflow.com/questions/10921645/ssis-how-to-get-part-of-a-string-by-separator

    Best of luck 🙂


    I'm on LinkedIn