Script Get Analysis Services Object Property Task

Overview

Script task to get Analysis Services object property.


Setup

The script has the following parameters:

Script UncompressZ Task

Overview

This script task can decompress data compressed with the unix "compress" utility (LZC, a LZW variant). This code is based heavily on the unlzw.c code in gzip-1.2.4 (written by Peter Jannesen) and the original compress code.


Script Init Task

Overview

A sample demonstrating SSIS script initialization setup with parameters provided by COZYROC SSIS+ library.


Script IMAP Task

Overview

Script task providing management functions for IMAP email server.


Setup

The script has the following parameters:

Script Get Environment Variable Task

Overview

Script task to retrieve environment variable.


Setup

The result is stored in specified ResultVariable package variable.


Script FTPS Task

Overview

Script task demonstrating FTP over SSL (FTPS) use.


Setup

The script has the following parameters:

  • Authentication with Username and Password
  • Support of upload file, download file, remote directory creation, remote directory removal, remote file deletion, remote file rename
  • Validation of specified parameters.
  • Supports "explicit SSL" only.

Script Data Record To Variable Task

Overview

Script task to extract field information from IDataRecord object into SSIS variables. The variable names have to match the field names.


Setup

The task has the following parameters:

  • DataRecordVariable - selects variable containing IDataRecord object.

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.


Pages