Transferring on time would not be a good solution. I thought of that one. Problem is when a record is inserted I may need it in the local table within 1 minute. On the flip side, there may not be any records for a period of hours.

My datasource is a SELECT on the table of thousands of records. However, I only need the record from INSERTED when a record is inserted into SQL_Remote.Customers. I'm just not seeing how to get that record.

Is there a way in SSIS, on the local server, to detect when a record is inserted in the remote server table SQL_Remote.Customers?

thanks!