CozyRoc SSIS+ 1.2 Library (Updated SR-2)

Overview

CozyRoc is the leading company providing advanced Microsoft SQL Server 2005 Integration Services (SSIS) library of custom tasks, components and scripts for handling Zip, GZip, BZip2, Tar archives, enhanced script reuse and secure internet communications. Our library of components helps you cut your development time by making you more productive. It is successfully deployed around the world.

If you have ideas about SSIS and data warehousing components, we will be glad to hear from you.

Download
CozyRoc SSIS+ vs. Microsoft Out-of-the-Box Functionality Microsoft OOTB CozyRoc SSIS+
Secure file transfer protocol (SFTP)   •
Reusable SSIS scripts Limited1 •
Reusable SSIS data flows Limited2 •
Zip, GZip, BZip2, Tar compression and decompression   •
Pass data between data flows Limited3 •
Access SSIS package object at runtime   •
Customizable user interface for SSIS scripts   •
Customizable setup of data flows   •

1 - Copy-and-paste reusability.
2 - Copy-and-paste reusability.
3 - Recommended solution with raw data source and destination is slower, unpredictable and storage space limited.

New! CozyRoc SSIS+ for SQL Server 2008 Beta 1

We have created a version of our SSIS+ library for SQL Server 2008. It does include all version 1.2 components, except Script Task Plus and Data Flow Task Plus. Support for these components will be added at a later time. This is preliminary release and it is not recommended for production use. Report if you have issues.

Download

SSIS Control Flow Tasks

Task Key Features

Data Flow Task Plus
Data Flow Task PlusData Flow Task Plus

  • Extension of Microsoft SSIS Data Flow Task.
  • Greater reusability and easier maintenance of data flows.
  • Customizable user interface for data flows setup.
  • SSIS data flows export, import or linking to.
  • Keep your data flows implementation separate from your package and have easier time tracking changes in your source control system.
  • Make Data Flow Task Plus interoperate with other data flows by using Data Flow Source and Data Flow Destination components.

Database Partitions Task
Database PartitionsDatabase Partitions

  • 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
Script Task PlusScript Task Plus

  • Extension of Microsoft SSIS Script Task, meaning you already have the skills to use it.
  • Greater reusability and easier maintenance of SSIS scripts.
  • 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.
  • Share your exported SSIS scripts with the community.

Zip Task
Zip TaskZip Task

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

SFTP Task
SFTP TaskSFTP 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 Task
SSH Execute TaskSSH Execute Task

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

SSIS Data Flow Components

Component Key Features

Data Flow Source Component
Data Flow SourceData Flow Source

  • Based on Package Connection Manager.
  • Very fast, non-blocking, in-memory data read from another data flow.
  • Scalable alternative of the recommended Microsoft solution with raw data file source.
  • User interface is based on the standard data flow source component dialog.
  • Check for yourself the performance by downloading this SSIS package.

Data Flow Destination Component
Data Flow DestinationData Flow Destination

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

SSIS Connection Managers

Connection Manager Key Features

SSH Connection Manager
SSH Connection ManagerSSH 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.

Package Connection Manager
Package Connection ManagerPackage Connection Manager

  • Get 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.