Recommend using Script Component in the Data flow. The split function is normally faster than anything in T-SQL and less complicated than most other options.