DTS: INSERT/UPDATE from one table to many tables

[muzirango]

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).

 

[xterra]

you should be able to create a lookup from the Transform Data Task Properties. you can create a seperate lookup for each table that needs to be updated. the syntax is the same as SQL so you can say
UPDATE TableB
SET TableBFieldName = TableACol1

do this for each table that you need to connect to. I am not positive but it should work.

Adam