The main database in Server A has 700 tables... but there is a database in ServerB that will have only a subset of it. (75-100 tables)..
This list can vary from week to week or month to month.. and when there is a request to refresh the data, all the data of tables in the list has to be sent over with the replace.
if the list is modified and some tables are added and some removed.. that should be reflected in the next refresh run.
what tasks are needed to get this done in SSIS?