Using Composite Keys

This snippet sample project demonstrates how to configure composite keys for updating and deleting records.

The sample uses a simple example for deleting a record from a SQL Customers table using multiple fields that make up the composite key. The process is the same for modifying a record using composite keys.


  1. InitializeTarget This activity initializes the Target activity that will be used for the deletion.

  2. DeleteRecord This activity is used for performing the actual record deletion.

Edit the DeleteRecord activity:

Then click on the Option property:

Select Composite Key as the key type and configure the collection of composite keys:

Last updated