web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Option set mapping in ...
Microsoft Dynamics CRM (Archived)

Option set mapping in ssis for the data migration to CRM

(1) ShareShare
ReportReport
Posted on by sandeepc 5,514

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

I have the same question (0)
  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    Hi sandeepc,

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

  • Suggested answer
    sandeepstw Profile Picture
    sandeepstw 4,601 on at

    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

  • Suggested answer
    Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at

    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.

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    does any1 know about cozyroc tool??

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    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 Profile Picture
    sandeepc 5,514 on at

    Any suggestions will be marked as verified

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    Hi sandeepc,

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

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    6787.ssis2.pngMapping parameter must contain IDictionary,string,recordset or dataset error

    6787.ssis2.png

    ssis3.png

  • sandeepc Profile Picture
    sandeepc 5,514 on at

    any suggestions

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    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.")

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans