SQL Server Performance Forum – Threads Archive
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.
I think DTS is no more help here, should write own code to insert in required way. _________