web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to import entity o...
Microsoft Dynamics CRM (Archived)

How to import entity owners using kingswaysoft SSIS tool?

(0) ShareShare
ReportReport
Posted on by Community Member

Hello guys. I want to set owners for different entities in my dynamics CRM like contacts,accounts or contracts.

For this purpose (in contacts entity for example ) I need  ownerid and owner "uniqueidentifier" and owneridtype "nvarchar".

I put on  ownerid field the user´s guid and owneridtype  I tried with (systemuser,user,team,Usuario (because my system is in spanish) or Equipo)

But this doesn´t work. Could you help me?

Thanks.

crm-destination.jpg

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: How to import entity owners using kingswaysoft SSIS tool?

    Thank you Aric Levin . My mistake was use 'systemsusers' instead of 'systemuser'.

  • Suggested answer
    Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,188 Moderator on at
    RE: How to import entity owners using kingswaysoft SSIS tool?

    Hola,

    It doesn't matter if your system is in English or Spanish the attribute names are still going to be English, so for User/Usario you need to use "systemuser", and for Team/Equipo you need to use "team". This is stored as nvarchar(64) in CRM.

    Can you confirm before reaching your CRM Destination Component that there are values in those fields? You can put a Data Viewer in front of the Destination component to see the data that will go into the different fields.

    Also, another thing, under Error Handler, what option do you have selected. If you choose Fail on Error, the system will break in case it hits an error, which might let you know what error you are experiencing.

    Some of the common things that I have seen is when the owner record that you are trying to insert does not have Read access to the record that you are adding them to.

    This should be a good starting point to troubleshoot. Please reply with your findings if you can't get it resolved.

    Buena suerte.

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
Christoph Pock Profile Picture

Christoph Pock 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans