Template Task

Overview

Template Task The Template Task is an SSIS Control Flow task for generation of text documents like XML, EDI, HTML, CSV, etc. The setup is done in two steps:

SCP Task

Overview

SCP Task The SCP Task is an SSIS Control Flow task for secure copying of files with an SSH server. For more advanced functionality check SFTP Task.

Zip Task

Overview

Zip Task The Zip Task is an SSIS Control Flow task for compression and decompression of Zip, GZip, BZip2, Unix (rfc1950) and Tar archives.

If you want to uncompress files created by the standard Unix "compress" utility, use this script.

Excel Task

Overview

Excel Task The Excel Task is an SSIS Control Flow task for management of Excel workbooks.

Receive Mail Task

Overview

Receive Mail Task The Receive Mail Task can be used to perform functions related to the reception and management of email. POP3, IMAP and Exchange email servers are supported. The task can handle email attachments as well as the emails themselves.

Data Flow Task Plus

Overview

Data Flow Task Plus
Data Flow Task Plus is an SSIS control flow task and it is an extension of the standard Microsoft Data Flow Task.

Send Mail Task

Overview

Send Mail Task The Send Mail Task Plus is an SSIS Control Flow task for sending e-mail. The task can also S/MIME sign and encrypt e-mails.

Parallel Loop Task

Overview

Parallel Loop Task The Parallel Loop Task is an SSIS Control Flow task, which can execute multiple iterations of the standard Foreach Loop Container concurrently. Based on actual tests, when a CPU-intensive process is run on a 4-core machine using this Parallel Loop Task, it executes 3 times faster as compared to running the same process sequentially.

File Transfer Task

Overview

File Transfer Task

This task replaced the SFTP Task as of SSIS+ 1.7. The name was changed because it can do much more than just work with files on an SFTP server. This task can be used to manage files on a remote server and to transfer files from or to a remote server. The remote connection may be any of the following:

Pages