Script Excel Refresh Task

Overview

Script task to refresh Excel connections and pivot tables.

Microsoft Excel must be installed in the environment where the package is executed.

Setup

The script has the following parameters:

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:

Pages