SBX - Search With Button

SBX - Forum Post Title

Option set mapping in ssis for the data migration to CRM

Microsoft Dynamics CRM Forum

sandeepc asked a question on 13 Jul 2018 10:30 AM
My Badges

Question Status

Suggested Answer

Hi,All

we are migrating  data from NAVISION to CRM by using SSIS.  We   have 10+ Option set fields in CRM.

In SSIS we are using MANUAL CRM OPTIONSET MAPPING by using Cozyroc tool.  Is there any way to add  filelds  DYNAMICALLY BY mapping

Reply
Adrian Begovich responded on 13 Jul 2018 8:47 PM
My Badges
Suggested Answer

Hi sandeepc,

You can achieve this with the KingswaySoft CRM Option Set Mapping Component.

Reply
Sandeep Mishra responded on 15 Jul 2018 7:49 AM
My Badges
Suggested Answer

Hi,

There is no way to map more than one option set at a time (maybe something Kingswaysoft will implement in the future).

www.kingswaysoft.com/.../optionset-mapping

Reply
Aric Levin responded on 15 Jul 2018 10:06 PM
Suggested Answer

If the integer value that is representing the option set is the same in the source and target environments, you can bypass the mapping, and the integer value directly (at least in Kingswaysoft, not sure about CozyRoc).

If the values are different, you will need to add a separate Optionset Mapping Component for each Optionset that you want to map.

Hope this helps.

Reply
sandeepc responded on 16 Jul 2018 4:06 AM
My Badges

does any1 know about cozyroc tool??

Reply
sandeepc responded on 16 Jul 2018 4:28 AM
My Badges

actually we have got enough links for kingsway soft we are using cozyroc. we need an suggestion on cozyroc. can we do this using it?

Reply
sandeepc responded on 16 Jul 2018 4:46 AM
My Badges

Any suggestions will be marked as verified

Reply
Adrian Begovich responded on 16 Jul 2018 5:15 AM
My Badges
Suggested Answer

Hi sandeepc,

This article discusses data flow transformation to handle translation and creation of Dynamics CRM OptionSet values.with Cozyroc.

Reply
Adrian Begovich responded on 13 Jul 2018 8:47 PM
My Badges
Suggested Answer

Hi sandeepc,

You can achieve this with the KingswaySoft CRM Option Set Mapping Component.

Reply
Sandeep Mishra responded on 15 Jul 2018 7:49 AM
My Badges
Suggested Answer

Hi,

There is no way to map more than one option set at a time (maybe something Kingswaysoft will implement in the future).

www.kingswaysoft.com/.../optionset-mapping

Reply
Aric Levin responded on 15 Jul 2018 10:06 PM
Suggested Answer

If the integer value that is representing the option set is the same in the source and target environments, you can bypass the mapping, and the integer value directly (at least in Kingswaysoft, not sure about CozyRoc).

If the values are different, you will need to add a separate Optionset Mapping Component for each Optionset that you want to map.

Hope this helps.

Reply
Adrian Begovich responded on 16 Jul 2018 5:15 AM
My Badges
Suggested Answer

Hi sandeepc,

This article discusses data flow transformation to handle translation and creation of Dynamics CRM OptionSet values.with Cozyroc.

Reply

SBX - Two Col Forum

SBX - Migrated JS