For starters I created a field in the Users object in Salesforce where I can input the ownerid from Dynamics. Then I also created a field to get the respective ownerid in the Contacts object. I then map the same field to the ownerid in the Contact entity of Dynamics CRM. I also have a custom field wherein I have specified the owneridtype.
Now when I try to migrate the data I get these errors:
[Dynamics CRM Destination [12]] Error: An error occurred with the following error message: "System.Exception: An exception has occurred when processing the input value of 'ownerid' field: Error: Failed to set field 'ownerid' value to '[example GUID here]' for entity 'contact' (field type: Owner, value type: Guid). System.ArgumentNullException: Value cannot be null.
Parameter name: entityType (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.1.0.7311 - DtsDebugHost, v14.0.3002.145) (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.1.0.7311 - DtsDebugHost, v14.0.3002.145)System.Exception
: Error: Failed to set field 'ownerid' value to '[example GUID here]' for entity 'contact' (field type: Owner, value type: Guid). System.ArgumentNullException: Value cannot be null.
Parameter name: entityType (SSIS Integration Toolkit for Microsoft Dynamics 365, v11.1.0.7311 - DtsDebugHost, v14.0.3002.145)".
I've also tried using the lookup option but to no avail. I can also ignore the ownerid altogether but it defeats the purpose of trying to assign the Contacts to the right owners. Any help would be appreciated!