Home Forums Data Warehousing Integration Services How to get the data in destination database immediately when source table updates? RE: How to get the data in destination database immediately when source table updates?

  • January 3, 2013 at 2:10 am

    #1573205

    sram24_mca (1/3/2013)

    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

    Integration Services does not sound like the right tool for the job - it's not an always-on, data-drip-feed type solution. Have you considered CDC or replication instead?

    Rather than 'immediately', can you specify the maximum acceptable time between the data appearing in source and being copied to destination?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.