importing into multiple tables

Hi

I have a file that has two columns of data say.

"John" "Smith"
"Peter" "Jackson"
etc

Is there a way of of loading this into two seperate tables.

ie the forenames will go into a "Forename" table and the
surname into a "Surname" table.

I really want this to be done using the DTS designer rather than writing in ActiveX.

I have it working using 2 seperate transformation tasks but they run parallel but if say "Smith" had a problem loading to the table I want it also to rollback the loading of "John" but allow the rest of the file to continue.

This is driving me up the wall. My boss recently met up with Microsoft and a guy siad it was easy to do in the Designer but my boss forgot what he told him..

PS I am currently using the eveluation edition.. This hasnt got this feature turned on in it has it???

Yes - this is simple to do using the DTS import/export wizard.
Simply right click on your DB, choose All Taks -> Import, and follow the prompts - you need to do two seperate runs as you're splitting the data up.