SSIS import, splitting data by delimiter

[Homerboy]

I have a column "NAME" that is first and last names combined, always divided by a "/" in a flat file that is being imported into a table.

I'd like to, on import, divide this by the "/" delimiter into 2 separate columns FIRST and LAST (and return the full, default "NAME" column too I guess).

I assume I can do this using a data flow transformation? Conditional split maybe?

If I'm correct on the above, I'm not quite sure how to do it...

any advice would be appreciated.

Thanks.

 

[KLin]

The Import/export wizard allows you to select your delimiter

http://msdn.microsoft.com/en-us/library/ms140052.aspx