An efficient approach to complete this task would be:
Maintain a lookup table/ file containing the list of tables and their source, which needs to be copied.
Then, we can use the lookup activity and each loop activity to scan through the list.
Inside the for each loop activity, we can use a copy activity or a mapping dataflow to copy multiple tables to the destination datastore.
