CozyRoc SSIS+ 1.3 Library (Beta 3)
The next version of the SSIS+ library. It includes new components for public-private key encryption (OpenPGP), interaction with Amazon S3 service, interaction with Jabber/XMPP clients, EDI format files reading and bulk-load data flow destination components for all major databases: Oracle, DB2 and Informix. This version includes also a new license verification system. The SQL Server 2008 version excludes Script Task Plus and Data Flow Task Plus. Support for these components will be added at a later time. For more information, check the components description below. This is preliminary release and it is not recommended for production use. Report if you have issues.
|
For SQL Server 2005
|
For SQL Server 2008
|
CozyRoc SSIS+ 1.2 Library (Updated SR-3)
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.
| 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 |
|
• |
| Public-Private key encryption |
|
• |
| Amazon S3 service interaction |
|
• |
| Bulk-load support for all major databases |
|
• |
| Jabber/XMPP client interaction |
|
• |
| EDI format files processing |
|
• |
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.
SSIS Control Flow Tasks
| Task |
Key Features |
|
Data Flow Task Plus Data 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 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 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 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 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 Task
|
|
|
Beta! PGP Task PGP Task
|
- Public key cryptography based on OpenPGP standard.
- Support for file encryption, decryption, signature creation and verification.
- Support for input and output data streaming, without a need for temporary storage.
- Streamlined user interface.
|
|
Beta! Amazon S3 Task Amazon S3 Task
|
- Based on Amazon S3 Connection Manager.
- Support file sending, receiving, removing and retrieval of remote files list.
- Support for input and output data streaming, without a need for temporary storage.
- Streamlined user interface.
|
|
Beta! Jabber Task Jabber Task
|
- Based on Jabber Connection Manager.
- Support bidirectional communication with Jabber clients - sending and receiving of messages.
- Support text or HTML message sending.
- Streamlined user interface.
|
|
Beta! Stream Task Stream Task
|
- Support creation of stream, opening of file stream, reading from stream and writing to stream.
- Support in-memory transfer stream, allowing simultaneous writing of data in one process and reading of the same data in another process.
- Streamlined user interface.
|
SSIS Data Flow Components
SSIS Connection Managers