I am trying to load 2 weeks data from db2 to sql server. I am using time range in where clause and loading it into the target. Once 2 weeks data is loaded the next 2 weeks data has to be loaded and it should continue till current date. I created 2 variables for start date and end date but i am not able to figure out how to use the 2 weeks date in loop. When 2 weeks data done the next 2 weeks has to be loaded. Can anyone help?
Do you mean you want to keep the current 2 weeks rolling data in the source tables. So past 2 weeks expires and next 2 weeks loads, so always only 2 current weeks in source DM.