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.

Activities:

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: