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:
Last modified 1yr ago