Skip to content

Deleting Elastic Table Records in Dataverse Using Alternate Key in SSIS (KingswaySoft)


Had written a post on deleting the elastic table record earlier – How to Delete Elastic Table Records in Dataverse (SDK). We need to pass the partitionid value through an alternate key to delete the elastic table records. We will have the alternate key auto-created by the system when we create an elastic table. Earlier specifying an Alternate Key was not possible for the Delete action in the CDS Destination component. However, with the latest release (Version 25.1 – April 4, 2025), the Manually Specify and Alternate Key matching criteria support has been added when performing the Delete action as shown below. We also need to have the Use Homogeneous Batch Operation Message option checked, this uses DeleteMultiple request in the background.

On running the package, now we can see the elastic table records (having partitionid) getting deleted successfully.

A screenshot of a computer

AI-generated content may be incorrect.

After the successful run (here we are deleting 40K records), we can see the records deleted.

A screenshot of a computer

AI-generated content may be incorrect.

Hope it helps..

Advertisements


Discover more from Nishant Rana’s Weblog

Subscribe to get the latest posts sent to your email.

Unknown's avatar

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Nishant Rana originally posted this article on 5 May 2025 at 8:30 PM.

Leave a Reply