OptionSet Mapping in KingswaySoft SSIS

Arpit Malhotra, 16 April 2019

Mapping CRM OptionSets is fairly simple when migrating data using KingswaySoft SSIS. It allows you to either map the options using the optionset value or using the optionset name. However, things may become complex if your source and the destination system have optionsets with different value and different names.

This is where the ‘Dynamics CRM OptionSet Mapping’ component comes to the rescue. Rather than changing the option value or name on either side of your system, you can simply use the Dynamics CRM OptionSet Mapping component to transform the optionsets to the options that your destination system is expecting. This blog describes the steps required to do the same:

Step 1: Setup OptionSet Mapping component between your source and the destination flow tasks.

Step 2: Fill the below options:
•    Input Column: Select the field to receive the data from.
•    CRM Connection Manager: Choose the target Dynamics system.
•    CRM Entity: Choose the desired entity in the destination system.
•    Option Set/Picklist Field: Specify the optionset for mapping.

Step 3: Add your mapping by clicking on the add (+) icon and, define the Input and the OptionSet value.

This wizard also lets you import and export the optionset mappings. You can also further handle non-matched values from the Action dropdown menu having choices as below:

Create option: This creates a new option of the chosen input value for the specified optionset field if no match is found.
Replace as an existing option: You can specify another option value to be used if no match is found.
Set as empty: As the name describes, it sets the output value of the column to empty if no match is found.
Leave it as is: This is the default value which passes the chosen input value.
Raise an error: This option throws an exception and stops the complete process if no match is found.

Your optionset mapping will work seamlessly after setting up the mapping editor. This can also be set up with integrations between your systems on an ongoing basis.