Forum Discussion
Process Add with partitions in SSMS
If you're using "process add" you need to make sure your query doesn't return any data that has been loaded before. To be honest I don't believe too many people are using "process add", because it requires quite some programming to do this reliable in an operational enviroment.
You might be better of using incremental refresh.
You can't run a "process add" with the same source data twice. If you want to reload a partition you need "process data" or "process full"; or run a "process clear" prior to the add.
I don't think that's the problem because I need to use 'process add' to process only new rows, if I can't use it so how is it even useful ? I mean process full & data processes the whole data and I need only new data.
If you're using "process add" you need to make sure your query doesn't return any data that has been loaded before. To be honest I don't believe too many people are using "process add", because it requires quite some programming to do this reliable in an operational enviroment.
You might be better of using incremental refresh.