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

Leave a comment