With SSIS, I want to insert a record in a CRM table (Contact). In the ownerid field I am inserting the ID of a team, since the owner of the record is a team. But this insertion is not possible, it looks like the system only looks for users and not teams as owners:
[Dynamics CRM Destination [94]] Error: An error occurred with the following error message: "System.Exception: (1) Error: systemuser With Id = cc3b2c21-62d2-e611-80dc-3863bb351f50 Does Not Exist
How can I insert a record specifying that the ownerid must be searched in the teams table?
Edit (in reply to Pawel Gradecki's comment): these are the records about the owner in the Contact entity:
You have to set also OwnerIdType which is 8 for a SystemUser and 9 for a Team.
Update: Just to prove this column is available for mapping, I created a SSIS package that connects to an Online deployment of mine and mapped Contact. Here is the screenshot of how the columns look like: