Use of CRM OptionSet Mapping Component

The CRM OptionSet Mapping Component is an asynchronous SSIS data flow pipeline component offered since v3.0 that can be used to manage the translation and mapping of CRM OptionSet values. 

The CRM OptionSet Mapping Component includes the following two pages to configure how you want to perform the translation and mapping for CRM OptionSet values.

  • General
  • Mapping

The General page is used to specify general settings for the CRM optionset mapping component. The Mapping page allows you to create mappings of the optionset values, where you can also specify how you want to handle non-matched values. 

General page

The General page of the CRM OptionSet Component allows you to specify the general settings of the component. 

CRM OptionSet Mapping Editor

Input Column

The Input Column is the source system column that you receive data from, which you want to translate the text values to CRM OptionSet values. Note that you will get the translated OptionSet values from this column in the output of the current OptionSet Mapping component, which you can use as the input of the same OptionSet/Picklist field in your CRM destination component that you attach right after the current OptionSet Mapping component (OptionSet/Picklist field of our CRM destination component can take either string values or internal values).

CRM Connection Manager

The CRM OptionSet Mapping component requires a CRM connection in order to retrieve OptionSet metadata from the CRM server. The CRM Connection Manager option will show all DynamicsCRM connection managers that have been created in the current SSIS package.

CRM Entity

The CRM Entity option is used to specify the CRM entity that contains the OptionSet field which you need to work with.

OptionSet/Picklist Field

The OptionSet Picklist Field option allows you to specify which CRM OptionSet field you need to work with (OptionSet used to be called Picklist prior to CRM 2011) for the mapping.

Mapping page

In the Mapping page, you can specify how you map input values to the OptionSet values in the CRM system.

CRM OptionSet Mapping Editor

The top part of this window contains a grid which can be used to enter mapping values through four toolbar buttons. The first two buttons allow you to add or delete a mapping entry. The Import button allows you to import from a mapping that you previously saved or exported. The Export button allows you to export all mapping values in the grid to a .xml file so that edits can be made using a different tool that you feel more comfortable with.

The second part of the window is where you specify how to handle non-matched values. There are five options available.

Create option

When no match is found for a particular input value, this option allows you to create a new option using the input value for the specified CRM OptionSet/Picklist field.

When this option is chosen, you will be presented with the following two more options:

  • Internal integer value field (since v5.0) - Specify the input column which contains the internal integer value when creating the option.
  • Input column for statecode - This option is only available when the target OptionSet/Picklist field is statuscode, which allows you to specify the input value of statecode in order to create the statuscode option.
Replace as an existing option

When this option is used, you must specify the option value to be used if no match is found.

Set as empty

This option will set the output value of the column to empty if no match is found.

Leave it as is

This option allows you to pass through the input value without making any change when no match is found.

Raise an error

This option allows you to throw an exception which fails the component entirely when no match is found for a particular input value.