COZYROC SSIS+ 1.6 SR-3 Library

COZYROC is the leading company providing an advanced Microsoft SQL Server 2005, 2008, 2012 and 2014 Integration Services (SSIS) library of custom tasks, components and scripts for handling Zip, GZip, BZip2, Tar archives, enhanced script reuse, secure internet communications, public-private key encryption (OpenPGP), EDI format files processing, USPS Address validation, Salesforce integration, Microsoft Dynamics CRM, AX, GP, NAV integration, enhanced Microsoft Excel support, Microsoft SharePoint integration, integration with Sage applications, QuickBooks, NetSuite, OpenAir, SugarCRM, concurrent loop execution, dynamic data flows, distributed cache support, generation of arbitrary text documents (HTML, XML, CSV, EDI and more), enhanced tasks for handling emails (SMTP, IMAP, POP3, Exchange), interaction with Amazon S3 service, interaction with Jabber/XMPP clients and bulk-load data flow destination components for all major databases: Oracle, DB2, Teradata and Informix. Our library of components makes you more productive by cutting your development time. COZYROC SSIS+ has been successfully deployed around the world.

Do you create custom solutions for clients? If so, do you want to know about COZYROC’s special terms for you? Do you have ideas about SSIS and data warehousing components? We would love to hear from you about your ideas for enhancements and additional components.

Note: If you have a previous version of the library installed, please uninstall it before installing the newer version.

SQL Server 2005, 2008, 2008R2, 2012, 2014

SQL Server 2005, 2008, 2008R2, 2012, 2014

All Downloads ----- Join VIP ----- Questions?

COZYROC SSIS+ vs. Microsoft Out-of-the-Box Functionality Microsoft OOTB COZYROC SSIS+
Application adapters for Salesforce, SharePoint, Dynamics CRM, AX, NAV, GP, Sage, QuickBooks, NetSuite, OpenAir, SugarCRM, Amazon S3  
Secure file transfer protocol (SFTP, FTPS)  
Reusable SSIS scripts Limited1
Reusable dynamic data flows Limited1
Zip, GZip, BZip2, Tar compression and decompression  
Pass data between data flows Limited2
Access SSIS package object at runtime  
Public-Private key encryption  
Bulk-load support for all major databases  
Jabber/XMPP client interaction  
EDI format files processing  
Generation of arbitrary text documents  
US Postal Address verification and correction  
Secure advanced email support (SMTP, IMAP, POP3, Exchange)  
Support Microsoft Excel workbooks in 64 bit  
Concurrent loop execution  

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

COZYROC Excel Add-in for SAS®

The COZYROC Excel Add-In for SAS® is designed to allow for the easy movement of SAS® data to and from an Excel worksheet. The Addin allows for the loading and saving of SAS® datasets. Here are the highlights of the product:

  • No SAS® software is required for the product.
  • Loads and saves SAS® datasets.
  • Supports Microsoft Excel 2003, 2007, 2010.
  • Supports Windows XP, Vista, 7, 8.
  • Supports SAS7BDAT files.
  • Designed for smaller datasets (under 100k observations).

COZYROC SSIS+ Library Details

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.
  • Support for dynamic data flows.

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 and up.
  • 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.
  • Reusable scripts and samples from the public repository.

Zip Task
Zip TaskZip Task

  • Compression and decompression of Zip, GZip, BZip2, Unix, Tar archives.
  • Automatically switches to Zip64 format, if it is required.
  • Support for input and output data streaming, without a need for temporary storage.
  • Support extraction from multi-volume Zip archive (1.3 SR-3).
  • Support AES encryption and decryption (1.5 SR-2).
  • Streamlined user interface.

SFTP Task
SFTP TaskSFTP Task

  • Based on SSH Connection Manager.
  • Based on FTPS Connection Manager (1.3).
  • Secure FTP communications and management.
  • Support for send, receive and delete files, create and remove directory, rename file commands.
  • Support for input and output data streaming, without a need for temporary storage.
  • 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

OpenPGP Task
OpenPGP TaskOpenPGP 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.

Amazon S3 Task
Amazon S3 TaskAmazon 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.

Jabber Task
Jabber TaskJabber 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.

Stream Task
Stream TaskStream 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.

Template Task
Template TaskTemplate Task

  • Generation of arbitrary text documents like CSV, HTML, XML, EDI and many more.
  • Streaming document generation, meaning low memory requirements and unlimited document generation.
  • Template engine based on Apache Velocity.
  • User interface includes syntax-highlighting editor and template-testing tools.

SCP Task
SCP TaskSCP Task

Send Mail Task Plus
Send Mail Task PlusSend Mail Task Plus

Receive Mail Task
Receive Mail TaskReceive Mail Task

Excel Task
Excel TaskExcel Task

  • Based on Excel Connection Manager.
  • Support 64 bit execution.
  • Support creating, deleting, clearing and renaming of worksheets.
  • Support find and replace of cells in Excel worksheets.
  • Streamlined user interface.

Parallel Loop Task
Parallel Loop TaskParallel Loop Task

  • Based on Package Connection Manager.
  • Improves loop execution time dramatically by executing multiple Foreach loop iterations concurrently.
  • Support both dynamic variables and dynamic connection managers.
  • Streamlined user interface.
Component Key Features

SAS® Data Source Component
SAS® Data SourceSAS® Data Source

  • Premium component licensed separately from SSIS+ library.
  • Installation and licensing of SAS® Analytics not required.
  • Streaming data read, allowing processing of unlimited amounts of data.
  • User interface is based on the standard data flow source component dialog.

SAS® Data Destination Component
SAS® Data DestinationSAS® Data Destination

  • Premium component licensed separately from SSIS+ library.
  • Installation and licensing of SAS® Analytics not required.
  • User interface is based on the standard data flow destination component dialog.

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.

Oracle Destination Component
Oracle DestinationOracle Destination

  • Bulk-load destination Oracle table component.
  • 10-30x faster loading speed compared to OLE DB.
  • Support for Oracle 9i release 2, 10g release 1, 10g release 2, and 11g release 1 databases.
  • User interface is based on the standard data flow destination component dialog.

DB2 Destination Component
DB2 DestinationDB2 Destination

  • Bulk-load destination DB2 table component.
  • 20x faster loading speed compared to OLE DB.
  • IBM UniData® and UniVerse® data servers are not supported.
  • User interface is based on the standard data flow destination component dialog.

Informix Destination Component
Informix DestinationInformix Destination

  • Bulk-load destination Informix table component.
  • 6-8x faster loading speed compared to OLE DB.
  • Support for IBM Informix® Dynamic Server, Version 11.10 or later.
  • User interface is based on the standard data flow destination component dialog.

EDI Source Component
EDI SourceEDI Source

  • Very fast reader of EDI format files. The component can reportedly process millions of segments in less than 30 minutes.
  • EDI mapping setup is made in XML configuration file.
  • User interface is based on the standard data flow source component dialog.

Script Component Plus
Script Component PlusScript Component Plus

  • Extension of Microsoft SSIS Script Component, 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.
  • Reusable scripts and samples from the public repository.

Address Parse Component
Address ParseAddress Parse

  • US Postal Address parsing, correction and standardization.
  • Parsed address parts: leading, street, number, suite, city, state, zip code.
  • Optional feature to check address in USPS reference database with more than 120 million addresses.
  • Intuitive user interface with fine-grained error control.

ODBC Destination Component
ODBC DestinationODBC Destination

  • Based on ODBC Connection Manager.
  • Support regular and bulk ODBC insertion.
  • Support 64bit ODBC drivers.
  • Support redirection of incorrect rows to error output.
  • User interface is based on the standard data flow destination component dialog.

Lookup Plus Component
Lookup PlusLookup Plus

  • Support OLEDB, ADO, ADO.NET or package variable as a source.
  • Support Distributed Cache (1.5 SR-1).
  • Support multiple lookup definitions in one place.
  • Support definition for handling NULL and No Match situations.
  • Intuitive user interface.

Salesforce Source Component
Salesforce SourceSalesforce Source

Salesforce Destination Component
Salesforce DestinationSalesforce Destination

Table Difference Component
Table DifferenceTable Difference

  • Memory efficient detection of differences between two tables.
  • Faster alternative of the standard SCD component.
  • Intuitive user interface.

Flow Synchronization Component
Flow SynchronizationFlow Synchronization

  • Makes two or more data flows run with same speed.
  • Intuitive user interface.

Dynamics CRM Source Component
Dynamics CRM SourceDynamics CRM Source

Dynamics CRM Destination Component
Dynamics CRM DestinationDynamics CRM Destination

Excel Source Plus Component
Excel Source PlusExcel Source Plus

  • Based on Excel Connection Manager.
  • Support 64 bit execution.
  • Support reading of raw, formatted and formula cell value.
  • Intuitive user interface with fine-grained error control.

Excel Destination Plus Component
Excel Destination PlusExcel Destination Plus

SharePoint Source Component
SharePoint SourceSharePoint Source

  • Based on SharePoint Connection Manager.
  • Support batch reading from Microsoft SharePoint list.
  • Support specifying of Microsoft SharePoint list view.
  • Support CAML queries and includes designer for simplifying query creation.
  • User interface is based on the standard data flow source component dialog.

SharePoint Destination Component
SharePoint DestinationSharePoint Destination

Dynamics AX Source Component
Dynamics AX SourceDynamics AX Source

Dynamics AX Destination Component
Dynamics AX DestinationDynamics AX Destination

SugarCRM Source Component
SugarCRM SourceSugarCRM Source

SugarCRM Destination Component
SugarCRM DestinationSugarCRM Destination

Dynamics NAV Source Component
Dynamics NAV SourceDynamics NAV Source

Dynamics NAV Destination Component
Dynamics NAV DestinationDynamics NAV Destination

NetSuite Source Component
NetSuite SourceNetSuite Source

NetSuite Destination Component
NetSuite DestinationNetSuite Destination

Dynamics GP Source Component
Dynamics GP SourceDynamics GP Source

Dynamics GP Destination Component
Dynamics GP DestinationDynamics GP Destination

Sage Source Component
Sage SourceSage Source

Sage Destination Component
Sage DestinationSage Destination

  • Based on Sage Connection Manager.
  • Store data into Sage entity.
  • Support write of composite Sage entity property.
  • User interface is based on the standard data flow destination component dialog.

OpenAir Source Component
OpenAir SourceOpenAir Source

OpenAir Destination Component
OpenAir DestinationOpenAir Destination

Template Component
TemplateTemplate

  • Generation on arbitrary text columns based on Apache Velocity template.
  • Support multiple template column definitions.
  • Intuitive user interface.

Teradata Destination Component
Teradata DestinationTeradata Destination

  • Bulk-load destination Teradata table component.
  • 80x faster loading speed compared to ODBC.
  • User interface is based on the standard data flow destination component dialog.

QuickBooks Source Component
QuickBooks SourceQuickBooks Source

QuickBooks Destination Component
QuickBooks DestinationQuickBooks Destination

Query Component
QueryQuery

  • Support OLEDB, ADO, ADO.NET connection types.
  • Support query statement setup from current data flow row.
  • Intuitive user interface.

Sybase Destination Component
Sybase DestinationSybase Destination

  • Bulk-load destination Sybase table component.
  • 20x faster loading speed compared to OLE DB.
  • Requires Adaptive Server Enterprise version 15.7.
  • User interface is based on the standard data flow destination component dialog.

Tableau Destination Component
Tableau DestinationTableau Destination

  • Creation of Tableau Data Extract (TDE) files.
  • Requires deployment of Data Extract API.
  • User interface is based on the standard data flow destination component dialog.
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.
  • Support SSH2.
  • Support File Transfer Protocol version 0, 1, 2, 3.
  • Support for secure tunnels (port forwarding) (1.5).
  • 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.

Amazon S3 Connection Manager
Amazon S3 ConnectionAmazon S3 Connection

Jabber Connection Manager
Jabber ConnectionJabber Connection

  • Connections with Jabber servers.
  • Support socket, HTTP polling and HTTP binding connection types.
  • Support for SOCKS4, SOCKS5, HTTP proxy.
  • Streamlined user interface.

FTPS Connection Manager
FTPS Connection ManagerFTPS Connection Manager

  • Secure connections with FTP over SSL server.
  • Secure connections with FTP over TLS server.
  • Connections with straight FTP server.
  • Support for Explicit and Implicit FTPS.
  • Support for OTP S/Key password protection.
  • Support for SOCKS4, SOCKS5, HTTP, FTP proxy.
  • Streamlined user interface.

Salesforce Connection Manager
Salesforce Connection ManagerSalesforce Connection Manager

  • Connections with Salesforce service.
  • Streamlined user interface.

Dynamics CRM Connection Manager
Dynamics CRM Connection ManagerDynamics CRM Connection Manager

  • Connections with Microsoft Dynamics CRM service.
  • Support Premise, Live, Hosted deployments.
  • Support Dynamics CRM 3, 4, 2011, 2013 systems.
  • Streamlined user interface.

SMTP Connection Manager
SMTP Connection ManagerSMTP Connection Manager

  • Connections with SMTP mail server.
  • Support secure connections.
  • Streamlined user interface.

POP3 Connection Manager
POP3 Connection ManagerPOP3 Connection Manager

  • Connections with POP3 mail server.
  • Support secure connections.
  • Streamlined user interface.

IMAP Connection Manager
IMAP Connection ManagerIMAP Connection Manager

  • Connections with IMAP mail server.
  • Support secure connections.
  • Streamlined user interface.

Excel Connection Manager
Excel Connection ManagerExcel Connection Manager

  • Connections to Microsoft Excel workbook files.
  • Support 64 bit execution.
  • Support Microsoft Excel 97-2010 and Pocket Excel workbook files.
  • Support password-protected workbooks.
  • Streamlined user interface.

SharePoint Connection Manager
SharePoint Connection ManagerSharePoint Connection Manager

  • Connections with Microsoft SharePoint service.
  • Streamlined user interface.

Dynamics AX Connection Manager
Dynamics AX Connection ManagerDynamics AX Connection Manager

  • Connections with Microsoft Dynamics AX server.
  • Support Dynamics AX 2012, 2009, 4.0 systems.
  • Streamlined user interface.

Distributed Cache Connection Manager
Distributed Cache Connection ManagerDistributed Cache Connection Manager

SugarCRM Connection Manager
SugarCRM Connection ManagerSugarCRM Connection Manager

  • Connections with SugarCRM web service.
  • Streamlined user interface.

Dynamics NAV Connection Manager
Dynamics NAV Connection ManagerDynamics NAV Connection Manager

  • Connections with Dynamics NAV web service.
  • Streamlined user interface.

Exchange Connection Manager
Exchange Connection ManagerExchange Connection Manager

  • Connections with Exchange web service.
  • Support Exchange 2010 and above.
  • Support for mail send and receive.
  • Streamlined user interface.

NetSuite Connection Manager
NetSuite Connection ManagerNetSuite Connection Manager

  • Connections with NetSuite web service.
  • Streamlined user interface.

Dynamics GP Connection Manager
Dynamics GP Connection ManagerDynamics GP Connection Manager

  • Connections with Dynamics GP web service.
  • Streamlined user interface.

OpenAir Connection Manager
OpenAir Connection ManagerOpenAir Connection Manager

  • Connections with OpenAir web service.
  • Streamlined user interface.

Sage Connection Manager
Sage Connection ManagerSage Connection Manager

  • Connections with Sage SData web service.
  • Streamlined user interface.

QuickBooks Connection Manager
QuickBooks Connection ManagerQuickBooks Connection Manager

  • Connections with QuickBooks web service.
  • Support for QuickBooks Online.
  • Support for QuickBooks Desktop.
  • Streamlined user interface.