How to use SSIS for real time data flow

Viewed 17

I have a scenario where if any updates happening in source DB that should also flow to destination DB in real time with no/minimum latency. I know we can use SSIS for this ETL process. But how would I trigger SSIS package as soon as updates happened in source. Is there any way to achieve this real time data transmission trough SSIS? If not, which tool/technology would be suitable for this scenario.

0 Answers
Related