I am creating an SSRS package to copy data from 1 source DB to a target DB on a daily basis.
Data is loaded into the source DB on a daily basis via an ETL tool. I then need to subsequently transfer that 'new daily data' only to the target database.
Q. How do I ONLY select the new 'daily' data within my SSRS package, so that duplicate data is not transferred also.
Note, the package contains 30-40 tables, and each of the tables have a TimeStamp field.