SQL Server Performance

DTS: INSERT/UPDATE from one table to many tables

Discussion in 'SQL Server DTS-Related Questions' started by wango, Oct 30, 2003.

  1. wango New Member




    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
  2. ykchakri New Member

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

    I think DTS is no more help here, should write own code to insert in required way.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com

Share This Page