No votes yet


Overview

Script task to perform Dynamics CRM bulk delete.


Setup

The script has the following parameters:

  • CrmConnection - selects Dynamics CRM Connection.
  • JobName - specifies job name.
  • QuerySet - specifies FetchXML for the records you want deleted.
  • StartDateTime - specifies bulk delete job start date and time.
  • RecurrencePattern - specifies job recurrence pattern. Use the syntax described in RFC2445
  • JobIdResultVariable - selects variable to store the job identifier.
  • SendEmail - specifies whether an email notification is sent after the job finishes executing.
  • ToRecipients - specifies recipient identifiers to receive notification email. Multiple recipients are separated with semicolon (;).
  • CCRecipients - specifies CC'd identifiers to receive notification email. Multiple recipients are separated with semicolon (;).

Requirements

Depends on COZYROC Script Task Plus component for implementing parameters user interface.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.Dynamics
  • CozyRoc.SSISPlus
  • System.Web.Services

ScriptMain