Share
Report
2,665Hi,
I am working on data migration, where in I have to migrate three entities which are related to one another. I mean entity A is 1:N with entity B and entity B is 1:N with entity C.
What I am doing is, in the control flow, I have three different data flow tasks. One for entity A which is connected to entity B data flow and entity B is in turn is connected to entity C data flow. When I run the package, entity A and entity B are migrating fine, their relationship stays intact, records with data is migrating completely fine. But for the entity C data flow, I am getting this error: new_entity C With Id = XXX Does Not Exist. What am I doing wrong? When entity A and entity B relationship is getting migrated without any errors, why is entity B and entity C relationship failing? Why is it expecting to have child record of entity C in destination? I am doing an upsert in both the cases, so that if the entity C does not exist, it has to create it or if it exists, it should update.. right? Someone please guide me through this. If this approach itself is not correct, please let me know how to handle these scenarios. Thanks for any help!
All responses (
Answers (
