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.
- Compression and decompression of Zip, GZip, BZip2, Unix, Tar archives.
- Automatically switches to Zip64 format, if it is required.
- Streamlined user interface.
- Secure connections with SSH-enabled server.
- Authenticate with password or private key file.
- Support for Tunnel (HTTP), SOCKS4, SOCKS5 proxy.
- Streamlined user interface.
- 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.
