Option set mapping in ssis for the data migration to CRM

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi,

I am migrating my data from oracle to CRM by using SSIS. I have 10 Option set fields in CRM.

In SSIS i am using DYANAMIC CRM OPTIONSET MAPPING by using Kingswaysoft tool. But it can map only one field at a time. Is there any way to add more filelds mapping by using same one?

https://www.kingswaysoft.com/products/ssis-integration-toolkit-for-microsoft-dynamics-365/help-manual/crm/optionset-mapping

Thanks.

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

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

Thanks for your quick response, Okay I will use derived transformation in ssis for these kind of scenario .

Thanks.
Suggested answer

Aric Levin 30,188 on at

Like (1)

Report

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

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

If you know the integer value of the your optionset, you can bypass it and link the value directly between source and destination (as long as they are the same).

Hope this helps.