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:14 am

    #1573208

    Phil Parkin (1/3/2013)

    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?

    Phil, I took "immediately" as meaning he wants to do it now rather than that he needs the source and destination to be always synchronised. I think we're going to need clarification.

    John