How to get the data in destination database immediately when source table updates

• sram24_mca

  SSCrazy

  Points: 2633

  More actions

  January 3, 2013 at 1:56 am

  #272407

  We have 2 databases Source Database and Destination Database, We want to transfer data from source table records to destination tables immediately .

  Can anyone provide tips to implement this by using Integration services ?

  Regards,

  Ram

• Phil Parkin

  SSC Guru

  Points: 246988

  More actions

  January 3, 2013 at 2:11 am

  #1573206

  Duplicate post. Responses here please.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel