Related records with Many to Many relationship using Kingsway soft SSIS tool

(0) Share

Report

Posted on by Nithin Vanam

Hello,

I am trying to migrate data from an excel file to related two custom records in Dynamics 365 which have an N:N relationship using Kingway Soft SSIS tool. I setup the Excel Source and CRM Destination, however within the CRM Destination i see only an option to select an entity but not its relationships.

My excel file contains two columns, one with an id for entity A and the second containing the id for entity B. How do i use the Kingsway soft tool to setup the relationship?

Any suggestions how i can achieve this?

I checked the xrmtoolbox tool that does what i am after but it takes a long time and i have to migrate close to a Million records so looking at Kingsway Soft solution for faster processing. Thanks in advance.

Regards,

Nithin

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Nithin,

Inside CRM/CDS Destination look for an entity that has a name of "intersection" entity of your N-N-relationship - that should give you the possibility to insert that N-N relationship.

Was this reply helpful? Yes No
Nithin Vanam 35 on at

Like (1)

Report
Copy link

Link copied!

Hi Andrew,

That did the trick. Thanks for your help.

Was this reply helpful? Yes No