Hi,
Can you please suggest how we can map owner of a record in SSIS Package destination component based on owner Id Type. Just to give a bit of background, We got few users with same full name as duplicates so I cannot use full name for mapping the Owner nor Guid (Because users and Teams Guids are different from source to destination). I am mapping Created By and Modified By with Guids by storing the legacy Guid's of users in single line of text field on destination CRM. While coming to map the owner field I cannot use the same approach because owner might be a user or a team so how I can map the owner based on their Ownerid Type. Please suggest.
Many Thanks in advance!!
*This post is locked for comments