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
You can achieve this with the KingswaySoft CRM Option Set Mapping Component.
There is no way to map more than one option set at a time (maybe something Kingswaysoft will implement in the future).
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.
does any1 know about cozyroc tool??
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?
Any suggestions will be marked as verified
This article discusses data flow transformation to handle translation and creation of Dynamics CRM OptionSet values.with Cozyroc.
Mapping parameter must contain IDictionary,string,recordset or dataset error
It looks like you may have hit the exception in the below line of code. It is found on line 784 of the article I posted.
Throw New Exception("Mapping parameter must contain IDictionary, String, Recordset or DataSet.")
Its working now. but where are those values will be stored as in db it is not showing in stringmapbase table
It is hard to say without seeing your SSIS Package. The values will only end up in the database if you have mapped them into a database destination component.
Business Applications communities