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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Cannot Insert GUID to Contact ownerid when migrating from Salesforce to Dynamics using Kingswaysoft SSIS Integration Toolkit

(0) ShareShare
ReportReport
Posted on by 15

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!

  • Suggested answer
    Saad Kabarousse Profile Picture
    734 on at

    Hello,

    In order to set the owner, you have to set OwnerIdType field too, it's an integer that contains 1 if the owner is a System user and 2 for Team and 4 for BusinessUnit

  • MRic Profile Picture
    15 on at

    Thanks for the reply, however I have already done this and it still gives me the same error

  • Suggested answer
    bialix Profile Picture
    370 on at

    Hello,

    Actually, I've created 2 custom columns before upserting a record.

    First contains team/user guid, second - 8 for systemuser and 9 for team.

    First was used as ownerid, second as owneridtype.

    It couldn't work for a long time. Then I realized, that I'm missing few privileges on integration account. After adding possibility to create records of certain entity it worked like a charm.

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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 109 Super User 2026 Season 2

#2
Syed Aqib Raza Profile Picture

Syed Aqib Raza 88

#3
ParthPatel249 Profile Picture

ParthPatel249 82

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans