ssisdynamics-crm-2016

Dynamics Crm insert record with SSIS


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:

enter image description here


Solution

  • You have to set also OwnerIdType which is 8 for a SystemUser and 9 for a Team. enter image description here

    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:

    Online connection for contact