db-table to db-table

Hi

Need some advice. I want to update a table with data coming from another table in another db. Basically I want some kind of trigger to kick of a pull using the sql adapter. Or maybe schedule it every 10sec? What is best here?

Another question, should I use a separate staging table? My original table(s) populates a staging table using a stored procedure. My integration then poll this table and put some kind of flag on every record that is alreay being fetched. Perhaps that is the best. I do not want to modify my original tables with new fields for update-status etc.

Anyone done something similar?