Using Alternate Key to set Lookup in SSIS (KingswaySoft) – Nishant Rana’s Weblog
Alternate Keys which were introduced with CRM 2015 Update 1, gave us the ability to Upsert and Update records, by defining one or more fields as Alternate Key and use that field(s) instead of relying only on Primary Key.
Alternate Keys can also be used for setting or updating the lookup instead of GUID.
CDSCRM Destination Component in KingswaySoft SSIS Integration Toolkit allows us the option of specifying the Alternate Key for updating the lookup field.
Suppose we have Contact entity…
Continue Reading Nishant Rana’s Article on their blog
Blog Syndicated with Nishant Rana’s Permission
More About This Author
- Dyn365CE24 September 2023Use Content Ideas Copilot to generate email content ideas (Dynamics 365 Marketing)
- Dyn365CE21 September 2023Step by step – Deleting an existing plugin from Plugin Assembly (Dataverse)
- Dyn365CE21 September 2023Filtering Attributes for Create message – Plugin (Dataverse / Dynamics 365)
- Dyn365CE20 September 2023Use Query Assist Copilot to create Segments (Dynamics 365 Marketing)