Dynamics CRM User Access Destination

No votes yet

Overview

Data flow destination, establishing user access permissions to entities. The script has the following parameters:

  • CrmConnection – selects COZYROC Dynamics CRM connection.
  • TargetEntity (Mappings) – map input column containing target entity.
  • TargetId (Mappings) – map input column containing target entity record identifier.
  • PrincipalEntity (Mappings) – map input column containing principal entity.
  • PrincipalId (Mappings) – map input column containing principal entity record identifier.
  • AccessRights (Mappings) – map input column containing access rights. The input should contain integer value with combination of one or more of the following values:
    Permission CRM 2011 CRM 4, CRM 3
    None 0 N/A
    ReadAccess 1 1
    WriteAccess 2 2
    AppendAccess 4 4
    AppendToAccess 16 8
    CreateAccess 32 16
    DeleteAccess 65536 32
    ShareAccess 262144 64
    AssignAccess 524288 128

Requirements

Depends on COZYROC Script Component Plus component for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.6 library.

Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • CozyRoc.Dynamics
  • System.Web.Services
  • System.XML

ScriptMain