Dynamics CRM Audit Logs Query

No votes yet


Data flow transformation to retrieve Dynamics CRM audit log records. Make sure that the audit logs feature is enabled for that entity.

The script has the following parameters:

  • CrmConnection – selects Dynamics CRM Connection.
  • BatchSize – specify the amount of records to retrieve in one web service call.
  • InsertTerminator – indicates whether an empty line should be inserted at the end of each set of detail records.
  • Entity – map to input column containing the entity name (Mappings Tab).
  • Id – map to input column containing the entity record identifier (Mappings Tab).


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