DTS Package and Triggers

• Frederick Robinson

  SSC Journeyman

  Points: 83

  More actions

  July 9, 2004 at 1:46 pm

  #162191

  I have the requirement to copy data from a table from one SQL Server to an identical table in another SQL Server. I need for the data to be copied from the first server when a row is inserted. I believe I can use the DTS package to perform the copy for the row inserted to the other server and this could be done when the insert trigger on the first server is fired. From my question, you can tell I am new to this so any ideas or where I can find an example would be greatly appreciated.

  Thanks,

  Fred

   

• July 12, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Gabriel-126745

  SSC Veteran

  Points: 280

  More actions

  July 20, 2004 at 1:48 pm

  #515340

  You can try to use replication.If you need just one table to be syncronized you can specify this when you are making the publication.