DTS: INSERT/UPDATE from one table to many tables

I have a source TableA (with , say, columns TableACol1, TableACol2, and TableACol3).
I want to use DTS to transfer data say, TableACol1 to taget TableB, TableACol2 to taget TableC, TableACol3 to taget TableD.
I want to b able to "UPDATE" in some cases.
Is this possible? If so, can someone give me some clue as to what to do. I can use DTS to INSERT/UPDATE from one table to another but not from one table to many).

Omuzirango

You may have to create individual SQL tasks with Insert/update statements for each target table.