Script Get File List Task

Overview

Script task to get files list.


Setup

The script has the following parameters:

  • FileFolder - specifies file folder.
  • FileFilter - specifies file filter.
  • ResultVariable - selects variable where result is stored.

Script Mail Info List Task

Overview

Script task to manage IMailInfo list.


Setup

The task has the following parameters:

Script Timer Task

Overview

Script task which waits specified amount of time, given in seconds, before completing execution.


Setup

The script has one parameter - WaitTime - a floating point number, specifying the number of seconds to wait.

It can also be a JavaScript expression in the Angular form: {{= task.variables["SecondsToWait"].value }}. This one, for example, retrieves and returns the user defined SSIS variable, named SecondsToWait.


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.

Pages