Option set mapping in ssis for the data migration to CRM

(1) Share

Report

Posted on by sandeepc

5,005

Hi,All

we are migrating data from NAVISION to CRM by using SSIS. We 2500.123.JPG 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

*This post is locked for comments

All responses (12)

Answers (0)

Suggested answer

Adrian Begovich 21,009 Super User 2024 Season 2 on at

Like (1)

Report

RE: Option set mapping in ssis for the data migration to CRM

Hi sandeepc,

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.
sandeepc 5,005 on at

Like (0)

Report

RE: Option set mapping in ssis for the data migration to CRM

Its working now. but where are those values will be stored as in db it is not showing in stringmapbase table
Suggested answer

Adrian Begovich 21,009 Super User 2024 Season 2 on at

Like (1)

Report
RE: Option set mapping in ssis for the data migration to CRM

Hi sandeepc,

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.")
sandeepc 5,005 on at

Like (0)

Report

RE: Option set mapping in ssis for the data migration to CRM

any suggestions
sandeepc 5,005 on at

Like (1)

Report

RE: Option set mapping in ssis for the data migration to CRM

Mapping parameter must contain IDictionary,string,recordset or dataset error
Suggested answer

Adrian Begovich 21,009 Super User 2024 Season 2 on at

Like (1)

Report

RE: Option set mapping in ssis for the data migration to CRM

Hi sandeepc,

This article discusses data flow transformation to handle translation and creation of Dynamics CRM OptionSet values.with Cozyroc.
sandeepc 5,005 on at

Like (0)

Report

RE: Option set mapping in ssis for the data migration to CRM

Any suggestions will be marked as verified
sandeepc 5,005 on at

Like (0)

Report

RE: Option set mapping in ssis for the data migration to CRM

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?
sandeepc 5,005 on at

Like (0)

Report

RE: Option set mapping in ssis for the data migration to CRM

does any1 know about cozyroc tool??
Suggested answer

Aric Levin 30,188 on at

Like (1)

Report

RE: Option set mapping in ssis for the data migration to CRM

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.