SQLTeam.com | Weblogs | Forums

Incremental load ssis


I was asked a question...how will i do incremental load in ssis. I answered lookup. It was the wrong answer.
How would you do it? There is supposed to be a simple method using ssis.


the answer is, it depends. Do you have a way of identifying what has changed since the last run? Lookups are slow since they do a lookup on every row. Is there a way to load any changes or subset of all data to a staging table on the destination db? If so, then you run a merge to put the data into the destination table.

Thanks. If there isn't a staging table? What would you use?