Skip to main content

Notifications

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
    bialix Profile Picture
    370 on at
    RE: Cannot Insert GUID to Contact ownerid when migrating from Salesforce to Dynamics using Kingswaysoft SSIS Integration Toolkit

    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.

  • MRic Profile Picture
    15 on at
    RE: Cannot Insert GUID to Contact ownerid when migrating from Salesforce to Dynamics using Kingswaysoft SSIS Integration Toolkit

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

  • Suggested answer
    Saad Kabarousse Profile Picture
    734 on at
    RE: Cannot Insert GUID to Contact ownerid when migrating from Salesforce to Dynamics using Kingswaysoft SSIS Integration Toolkit

    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

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 225 Super User 2025 Season 1

#2
Eugen Podkorytov Profile Picture

Eugen Podkorytov 106

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 106 Most Valuable Professional

Overall leaderboard

Product updates

Dynamics 365 release plans