Hi, I'm trying to create a copy activity that copies from SQL to Dynamics CRM. I'm using the ADF v2 default connector. The Dynamics connectors as a sink have the upsert behavior but I don't know how to define the keys for comparing in the upsert. If I complete the configuration and the mapping, removing the unnecessary columns and I run the activity, I have the following error: Input DataSet must contain key column(s) in Upsert/Update scenario. Missing key column(s): Is there any way to set the keys in the input dataset?
The Alternate Key Name drop-down is always empty, and if I try to define the value manually I get the error: Failure happened on 'Sink' side. 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot retrieve key information of alternate key 'emailaddress1' for entity 'contact'.,