Thread: DTS transfer

I have a little DTS question.  does anyone know how to
use DTS feature to transfer a table of records onto 2 or more
different tables.

assume i have tableA from source and would like to split the record to
2 parts and transfer to TableB and TableC on destination db.

Thanks