It would be useful background info to have some idea of what your source and destination are - is this a flat file to SQL Server import, or something different?
I would probably be looking into using derived column transformations within your data flow to break up the name column.
SSIS is highly dependent on design-time meta data, so doing things like adding run-time columns will often be unworkable.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.