COZYROC SSIS+ 1.7 Library

If you have a previous version of the library installed, please uninstall it before installing the newer version.
To make COZYROC's components available in the new SSDT 17 version, change the target platform version to one of the other three available options: SQL 2012, SQL 2014, or SQL 2016.

Summary

COZYROC is the leading company providing an advanced Microsoft SQL Server 2005-2016 Integration Services (SSIS) library of custom tasks, components and scripts. Our library of components makes you more productive by cutting your development time. COZYROC SSIS+ library has been successfully deployed in more than 60 countries around the world. Check below some of the unique features not found in any other product on the market.

  • Powerful REST adapters for connection to cloud applications
  • Connectivity for Salesforce, SharePoint, Dynamics CRM, AX, NAV, GP, Sage, QuickBooks, NetSuite, OpenAir, SugarCRM, Amazon S3, ArcGIS, Dropbox, Fleet Complete, Hubspot, Marketo, OneDrive, Parature, Pardot, ServiceNow, Shopify, SimplyDigi, Square, Twitter, Xero, Zoho CRM
  • Secure file transfer protocol (SFTP, FTPS)
  • Reusable SSIS scripts
  • Reusable dynamic data flows
  • Concurrent loop execution
  • Zip, GZip, BZip2, Tar compression and decompression
  • Public-Private key encryption
  • Bulk-load support for all major databases
  • EDI format files processing
  • Generation of arbitrary text documents
  • US Postal Address verification and correction
  • Secure advanced email support (SMTP, IMAP, POP3, Exchange)
  • 64bit Microsoft Excel adapters

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.


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

Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
Learn More
Learn More
Learn More
  • 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.
Learn More
  • 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.
Learn More
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • 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.
Learn More
Learn More
Learn More
  • Memory efficient detection of differences between two tables.
  • Faster alternative of the standard SCD component.
  • Intuitive user interface.
Learn More
  • Makes two or more data flows run with same speed.
  • Intuitive user interface.
Learn More
Learn More
Learn More
  • 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.
Learn More
Learn More
  • 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.
Learn More
Learn More
Learn More
Learn More
Learn More
Learn More
Learn More
Learn More
Learn More
Learn More
Learn More
Learn More
Learn More
  • 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.
Learn More
Learn More
Learn More
  • Generation on arbitrary text columns based on Apache Velocity template.
  • Support multiple template column definitions.
  • Intuitive user interface.
Learn More
Learn More
Learn More
  • Support OLEDB, ADO, ADO.NET connection types.
  • Support query statement setup from current data flow row.
  • Intuitive user interface.
Learn More
  • 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.
Learn More
  • 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.
Learn More
  • Fast read from Teradata table.
  • User interface is based on the standard data flow source component dialog.
Learn More
  • 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.
Learn More
  • Read from QlikView QVX files.
  • User interface is based on the standard data flow source component dialog.
Learn More
  • Creation of QlikView QVX files.
  • User interface is based on the standard data flow destination component dialog.
Learn More
Learn More
Learn More
  • Read from LDAP object.
  • User interface is based on the standard data flow source component dialog.
Learn More
  • Insert data into LDAP object.
  • User interface is based on the standard data flow destination component dialog.
Learn More
  • 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.
Learn More
  • 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.
Learn More
Learn More
  • Connections with Jabber servers.
  • Support socket, HTTP polling and HTTP binding connection types.
  • Support for SOCKS4, SOCKS5, HTTP proxy.
  • Streamlined user interface.
Learn More
  • 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.
Learn More
  • Connections with Salesforce service.
  • Streamlined user interface.
Learn More
  • Connections with Microsoft Dynamics CRM service.
  • Support Office 365, Premise, Live, Hosted deployments.
  • Support Dynamics CRM 3 - 2016 systems.
  • Streamlined user interface.
Learn More
  • Connections with SMTP mail server.
  • Support secure connections.
  • Streamlined user interface.
Learn More
  • Connections with POP3 mail server.
  • Support secure connections.
  • Streamlined user interface.
Learn More
  • Connections with IMAP mail server.
  • Support secure connections.
  • Streamlined user interface.
Learn More
  • 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.
Learn More
  • Connections with Microsoft SharePoint service.
  • Streamlined user interface.
Learn More
  • Connections with Microsoft Dynamics AX server.
  • Support Dynamics AX 2012, 2009, 4.0 systems.
  • Streamlined user interface.
Learn More
Learn More
  • Connections with SugarCRM web service.
  • Streamlined user interface.
Learn More
  • Connections with Dynamics NAV web service.
  • Streamlined user interface.
Learn More
  • Connections with Exchange web service.
  • Support Exchange 2010 and above.
  • Support for mail send and receive.
  • Streamlined user interface.
Learn More
  • Connections with NetSuite web service.
  • Streamlined user interface.
Learn More
  • Connections with Dynamics GP web service.
  • Streamlined user interface.
Learn More
  • Connections with OpenAir web service.
  • Streamlined user interface.
Learn More
  • Connections with Sage SData web service.
  • Streamlined user interface.
Learn More
  • Connections with QuickBooks web service.
  • Support for QuickBooks Online.
  • Support for QuickBooks Desktop.
  • Streamlined user interface.
Learn More
  • Connections with REST web services.
  • Optional support for proxy.
  • Optional retry for particular errors.
  • Streamlined user interface.
Learn More
  • Connections with LDAP service.
  • Streamlined user interface.