New set of SSIS Tasks

These may have been around for a while, but I just discovered that there is a nice set of (affordable) SSIS tasks at CozyRoc.  There is a task for zipping files, managing partitions, SFTP and even using another dataflow as a source.  Here is the current info from their site:

 

Component
Key Features

Beta! Package SSIS Connection Manager

• Gain access to the current or different package at runtime.
• Support for all current types of package storage: SQL, File, SSIS Package Store.
• Support for package variables initialization before execution.
• Easy to use interface.

Beta! Data Flow Source SSIS Data Flow Component

• Based on Package Connection Manager.
• Very fast, non-blocking, in-memory data read from another data flow.
• Scalable alternative of the solution Microsoft is recommending with raw data file source.
• User interface is based on the standard data flow source component dialog.

Beta! Data Flow Destination SSIS Data Flow Component

• Exposes data from a data flow for in-memory read in another data flow.
• Scalable alternative of the solution Microsoft is recommending with raw data file destination.
• User interface is based on the standard data flow destination component dialog.

Database Partitions SSIS Control Flow Task

• Saves you time by handling the intricacies of the partitioning and letting you concentrate on your workflow instead.
• Create, insert and remove database partitions in Microsoft SQL Server 2005.
• Combine smaller partitions into a larger one, for easy backup later.
• Support for ADO.NET, OLEDB, ADO connection managers.
• Easy to use interface.

Script Task Plus SSIS Control Flow Task

• Extension of Microsoft SSIS Script Task, meaning you already have the skills to use it.
• Greater reusability and easier maintenance of script functionality.
• Customizable script user interface and setup.
• SSIS Script export, import or linking to.
• Keep your script code separate from your package and have easier time tracking changes in your source control system.
• Requires SQL Server 2005 SP2.
• New! Share your exported SSIS scripts with the community.

Zip SSIS Control Flow Task

• Compression and decompression of Zip, GZip, BZip2, Unix, Tar archives.
• Automatically switches to Zip64 format, if it is required.
• Streamlined user interface.

SSH SSIS Connection Manager

• Secure connections with SSH-enabled server.
• Authenticate with password or private key file.
• Support for Tunnel (HTTP), SOCKS4, SOCKS5 proxy.
• Streamlined user interface.

SFTP SSIS Control Flow Task

• Based on SSH Connection Manager.
• Secure-FTP (SFTP) communications and management.
• Support for SFTP commands send, receive and delete files, create and remove directory, rename file.
• The user interface covers most of the functionality of the standard Microsoft SSIS FTP task and it is very similar.

SSH Execute SSIS Control Flow Task

• Based on SSH Connection Manager.
• Secure execution of shell commands on a remote SSH server.
• Streamlined user interface.