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

Using Alternate Key to set Lookup in SSIS (KingswaySoft) – Nishant Rana’s Weblog

Blog Syndicated with Nishant Rana’s Permission

Author: Nishant Rana

Share This Post On