Just want to share my experience of using KingswaySoft’s OptionSet Mapping Editor and how easy and efficient it makes to migrate data in Microsoft Dynamics 365 CE.
Here our SQL (OLE DB Source) was having following values for Phone Code field. Here we are doing upsert for the Contact entity.
However inside CRM, we were only maintaining or dealing with few of the values as shown below for the corresponding field.
To deal with this situation, inside SSIS Package, drag the Dynamics CRM…
Continue Reading Nishant Rana’s Article on their blog
Easily map OptionSet using CRM OptionSet Mapping Editor in SSIS – Nishant Rana’s Weblog
Blog Syndicated with Nishant Rana’s Permission
More About This Author
-
• Microsoft Certified Professional in Microsoft Dynamics CRM (CRM 3.0 to CRM 2016), Microsoft SharePoint (2007 and 2013) and Microsoft .NET with 10+ years of experience.
• 10 years of working experience with Microsoft Dynamics CRM starting with CRM 3.0 to CRM 2016 on various project aspects: analysis, designing, developing, leading team etc.
• An avid blogger who likes to learn, help, share and contribute in Community.
• Author of “Nishant Rana’s Weblog” (https://nishantrana.wordpress.com/), technical blog on Microsoft .NET technologies with more than 2.5 million hits and 800 followers. The blog is also recognized as one of the top 35 blogs on Microsoft Dynamics CRM.
• Twitter account https://twitter.com/nishantranaCRM with more than 500 followers, which includes MVP(s) and experts in Microsoft Dynamics CRM.
• Technical Reviewer of following books on Microsoft Dynamics CRM.
https://nishantrana.wordpress.com/books-reviewed/
Latest Posts
- 2019.05.09#Dyn365CE{Dynamics 365 for Sales AI} How are relationship analytics calculated? Let Microsoft Docs tell you – Nishant Rana’s Weblog
- 2019.05.08#Dyn365CEThe “Derived Column” failed because truncation occurred, and the truncation row disposition on “Derived Column.Outputs[Derived Column Output].Columns[FilePath]” specifies failure on truncation. A truncation error occurred on the specified object of the specified component. – Nishant Rana’s Weblog
- 2019.05.02#Dyn365CEFixed – Workflows not firing “Waiting For Resources” in Dynamics 365 On-Premise – Nishant Rana’s Weblog
- 2019.04.25#Dyn365CEFixed – DTS_E_PROCESSINPUTFAILED. The Process input method on component “Script Component” failed with error code 0x80131501 in SSIS
