Developer forum

Possibility to have multiple imports to the same table AND delete old rows
... without any custom development

See: http://developer.dynamicweb-cms.com/forum/integration-data-integration/possible-to-only-delete-a-subset-of-rows.aspx

Large organizations often need to gather and merge data from multiple sources (subsidiary companies and departments).
With Data Integration we are not able to have data from multiple sources imported to the same table AND delete all the old rows.

Simplified example:
Acme Inc. needs to import users from Company A and Company B. Users are stored in two separate groups in user management (AccessUser) - Group A and B.
When users are imported from Company A into group A, all old users in that group should be deleted. Same goes for company B users in group B.
All other users in the table should NOT be deleted.
This is not possible with Data Integration. Correct me if I'm wrong.

I have previously implemented something similar in a custom activity for the old Import/Export module. Each import was assigned a systemname which was then stored on each row in the table along with an import timestamp. I'm not sure if this would work in Data Integration though and there is probably a more elegant solution to this.

/Morten