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. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>