Monday, November 26, 2007

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.