I have a requirement where source is MS Dynamics CRM (where have to extract data using fetchxml in SSIS).
The Contact Entity is having lookup to Organization (may have more than 1 contact for an organization) and Contact Types (possible values are Admin/User/Super User/Bespoke/Remove Access/Recognized User etc).
That means a contact can be an Admin and Remove Access for an organization and another contact can be only Remove Access for any other organization.
The requirement is to split Contacts based on below conditions.
- If contact is JUST setup as Recognised Organisation User or Remove Access in Portal Security.
- If contact is setup as Recognised Organisation User or Remove Access AND any other role in Portal Security.
- Action B
I am facing difficulty to split the contacts correctly.
Please suggest how this can be achieved. Thanks in advance.