How could i automate the following Task?: (DWH / Staging-Tables)
Loop through all the tables (from a list), and import the data from the current day (ImportDate = getdate ()) and copy the Data into an identical database on another server. Same DB-Structure (is a clone). Basically, following SQL would have to be generated for all tables:
INSERT INTO RemoteServer. [Dbo]. [Customer]
FROM LocalServer. [Dbo]. [Customer]
WHERE ImportDate = getdate()
Realize with SSIS, C #, T-SQL / Merge, SQL Server Tools, Replicate ....