Perform an incremental load of data

Perform an incremental load of data
 Tasks Required: 2 Execute SQL Tasks, Data Flow Task

Solution: Have the 1st Execute SQL Task retrieve a date from a control table of when the target table was last loaded and place that into a variable.
In the Data Flow Task, create a date range on your query using the variable. Then, update the control table using a 2nd Execute SQL Task to specify when the table was
last updated.