Script Dynamics CRM Bulk Delete Task

Overview

Script task to perform Dynamics CRM bulk delete.


Setup

The script has the following parameters:

Script SQL Job Agent Task

Overview

Script task providing basic manipulation operations for SQL Agent Jobs. You can enable, disable, start, stop or drop a Job. You can also check if job is enabled or the running status of the job.


Setup

The script has the following parameters:

Script Data Flow Enumerator Task

Overview

Script task to process data flow result into control flow.

This script task is elegant solution over the issue how to process the result of data flow transformation in SSIS control flow enumeration container. It implements wrapper over standard DataReader destination component. Each enumeration is of type IDataRecord.

Script JSON to Variables Task

Overview

Script task to bulk extract elements from JSON document into SSIS variables.

The input document should be a simple key-value pair where the key name will be the name of the variable where the value will be stored.

Example:

{
    varName1: varValue1,
    varName2: varValue2,
    varName3: varValue3,
    ...
}

Setup

The script has the following parameters:

Script REST Web Service Request Task

Overview

Script task to call a web API endpoint.


Setup

The script has the following parameters:

Script Transform XML Task

Overview

Script task to transform an XML document using an XSLT file.


Setup

The script has the following parameters:

Script SFTP Connection Exists Task

Overview

Script task to check if connection can be established.


Setup

The script has the following parameter:

  • FtpConnection - select connection to check.

Script Send Mail Task

Overview

Script task to send email thru SMTP server.


Setup

The script has the following parameters:

  • Authentication with Username and Password
  • Support of standard SMTP connection for connection to the server
  • Validation of specified parameters.
  • Support for rich HTML message body.
  • Support for attachments.

Script Secure Tunnel Task

Overview

Script task to establish secure tunnel using SSH protocol.


Setup

The script has the following parameters:

  • SshConnection - selects COZYROC SSH connection. The connection should use the new SSH backend.
  • LocalAddress - specifies tunnel's local address. The format is [address]:[port].
  • RemoteAddress - speicifies tunnel's remote address. The format is [address]:[port].

Script Package Configuration Task

Overview

Script task for alternative SSIS package configuration setup.


Setup

The script has the following parameters:

  • PackageConnection - the connection manager providing the package.
  • ConfigurationEnvironment - system environment variable containing the path to the Excel configuration file.
  • ConfigurationWorksheet - Excel worksheet containing the configuration.

The configuration is contained in Excel worksheet with two columns:

Pages