DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Average: 3.3 (125 votes)


Overview

Script task providing management functions for email server.


Setup

The script has the following parameters:

  • MailConnection - selects COZYROC IMAP or EXCHANGE connection.
  • Action - selects task action:
    • DeleteMail - deletes mail.
    • CopyMail - copies mail to folder.
    • MoveMail - moves mail to another folder.
    • CreateFolder - creates mail folder.
    • DeleteFolder - deletes mail folder.
    • GetFolders - gets list of folders.
    • SetMailSeen - sets mail read/not read.
  • MailVariable - selects variable containing mail reference information.
  • DestinationFolder - specifies destination mail folder.
  • ParentFolder - specifies parent mail folder for retrieving list of folders.
  • ResultVariable - selects variable where list of folders is stored.

Requirements

Depends on COZYROC Script Task Plus for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.6 library.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus

ScriptMain