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.

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

Hope it helps..