In that case I would most likely replicate those two tables.

But since you insist on using SSIS, you can create an agent job and then put a trigger on those tables that will cause that agent job to run when an update or insert occurs.