Download SSIS+ Releases

Before you download one of the COZYROC SSIS+ Suite installer packages below, please review the information on the Installation and Getting Started page to ensure a successful installation. The compatibility charts you will find on this page will help to guide you in understanding which Microsoft technology components (e.g., SSDT, Visual Studio) are compatible and supported by the COZYROC SSIS+ Suite release you are downloading.

After you have downloaded and installed one of the COZYROC release files below, you will be redirected to a page that has useful resources like Licensing the SSIS+ Suite, Task and Component documentation, tutorial videos and Knowledge Base articles.

SSIS+ 2.2

Release Notes

ActiveCampaign Connection
  • New: Introduced connection.
ADP Connection
  • New: Introduced connection.
Blackbaud Connection
  • New: Introduced connection.
ClickSend Connection
  • New: Introduced connection.
Close Connection
  • New: Introduced connection.
Copper Connection
  • New: Introduced connection.
Data Flow Task Plus
  • New: Support for Azure Flexible File Source and Destination components.
  • New: Context menu item "Remove Static Columns" when right-clicking on a component.
  • New: SSDT installation is no longer required during runtime.
Database Destination
  • New: Introduced component.
EDI Source
  • New: A new optional attribute segname for segment element in configuration file. If specified, the component will provide segment name information.
Elasticsearch Connection
  • New: Introduced connection.
Excel Destination
  • New: Ability to reference sheet by index (:index) when the sheet name is unknown.
Excel Source
  • New: Ability to reference sheet by index (:index) when the sheet name is unknown.
File Transfer Task
  • New: The result returned from 'Get remote files list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
FTPS Connection
  • New: Support for TLS 1.3.
Google BigQuery Connection
  • New: Support for service account authentication.
Google Drive Connection
  • New: Support for shared drives.
GoToWebinar Connection
  • New: Support for RFC 6749 compliant OAuth2 authentication.
  • New: Updated to GoToWebinar 2.0 REST API.
IMAP Connection
  • New: Support for TLS 1.3.
JSON Destination
  • New: Introduced component.
JSON Source
  • New: Introduced component.
Legacy Amazon S3 Task
  • New: The result returned from 'Get remote files list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
Linkedin Connection
  • New: Introduced connection.
monday connection
  • New: Introduced connection.
NetSuite Connection
  • New: Updated web service proxy to version v2019.2.
NetSuite Source
  • New: Support for join fields in a saved search.
  • New: Improved support for custom fields in a saved search (Thank you, Mauro).
OpenAir Connection
  • New: A new parameter ServerHost to support the new OpenAir service host requirement. The old ConnectionType parameter is no longer relevant and has been removed.
Pipedrive Connection
  • New: Introduced connection.
POP3 Connection
  • New: Support for TLS 1.3.
QuickBase Connection
  • New: Introduced connection.
QuickBooks Desktop Connection
  • New: Updated QuickBooks Online web service proxy to version 43.
  • New: A new parameter 'Start on Open' in QuickBooks Desktop Edition Gateway to automatically start the gateway when the application is opened.
  • New: Support for QuickBooks Online sandbox environment.
Receive Mail Task
  • New: The result returned from 'Get mail list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
REST Connection
  • Breaking Change: Resource.Field.Default attribute has been removed from the configuration schema.
  • New: Enable retrieving API tokens within a modern Chromium-based web browser component (as an alternative to the IE-based one).
  • New: OpenAPI import.
  • New: Authentication template for Google User Account.
  • New: Authentication template for Google Service Account.
  • New: Authentication template for Amazon Web Services Signature v4.
  • New: Iterator template for OData services.
Sage Business Cloud Accounting Connection
  • New: Introduced connection.
Salesforce Connection
  • New: Updated web service proxy to version 48.
SendGrid Connection
  • New: Introduced connection.
SharePoint Connection
  • New: Experimental feature to explicitly specify authentication token when using MFA-enabled service. For further information please review 'Establish connection to MFA-enabled service' Quick Start.
  • New: Support for on-premises servers that use ADFS authentication.
SharePoint Destination
  • New: An enhanced configuration dialog with improved columns mapping page.
SharePoint Source
  • New: An enhanced configuration dialog with improved output columns page.
Shopify Connection
  • New: Support for cursor-based pagination process.
SMTP Connection
  • New: Support for TLS 1.3.
SSH Connection
  • New: If key-file authentication fails, the connection will attempt password-only authentication (Thank you, Pavel).
Table Difference
  • New: A new 'Diagnostic Log' output to analyze the differences on a more granular level.
Tableau Connection
  • New: Introduced connection.
Teamwork Connection
  • New: Introduced connection.
UiPath Connection
  • New: Introduced connection.
Xero Connection
  • New: Support for OAuth2 authentication.
YouTube Connection
  • New: Introduced connection.
64-bit (x64) SQL Server 2012-2022
32-bit (x86) SQL Server 2012-2022
Development releases
Release Notes
64-bit (x64) SQL Server 2012-2022
32-bit (x86) SQL Server 2012-2022

SSIS+ 2.1

Release Notes

Acumatica Connection
  • New: Introduced connection.
Aircall Connection
  • New: Introduced connection.
Alchemer Connection
  • New: Introduced connection.
Amazon Athena Connection
  • New: Introduced connection.
Amazon S3 Connection
  • New: Introduced connection.
AMQP Connection
  • New: Introduced connection.
Azure Table Connection
  • New: Introduced connection.
BigCommerce Connection
  • New: Introduced connection.
Bloomerang Connection
  • New: Introduced connection.
Capsule CRM Connection
  • New: Introduced connection.
Dynamics Business Central Connection
  • New: Introduced connection.
Eventbrite Connection
  • New: Introduced connection.
Exchange Connection
  • New: Implemented to create OAuth2 version 2.0 access tokens for Exchange Online.
  • New: Store authentication token in a database.
File Transfer Task
  • New: Support for Salesforce connection.
  • New: A new AdditionalOptions parameter for specifying additional action options.
  • New: Support for recursive upload of sub-folders and files.
  • New: Parameters for Retry On Error.
Formstack Connection
  • New: Introduced connection.
Google BigQuery Connection
  • New: Improved parameter entry.
Google Cloud Storage Connection
  • New: Introduced connection.
Google Drive Connection
  • New: Improved parameter entry.
Google Maps Connection
  • New: Introduced connection.
Google People Connection
  • New: Introduced connection.
Google Sheets Connection
  • New: Improved parameter entry.
GoToWebinar Connection
  • New: Introduced parameters for specifying client id/secret during the authentication token generation.
IMAP Connection
  • New: Support for Google OAuth 2.0 authentication.
  • New: Support for Microsoft OAuth 2.0 authentication.
Infusionsoft Connection
  • New: Introduced connection.
JotForm Connection
  • New: Introduced connection.
Kafka Connection
  • New: Introduced connection.
Kintone Connection
  • New: Introduced connection
KRONOS Connection
  • New: Support for global reports.
LDAP Connection
  • New: Attributes from auxiliary classes (sAMAccountName, etc) are now included.
Linkedin Connection
  • New: Support for 'Page Statistic' resource.
Message Queue Task Plus
  • New: Introduced task.
Microsoft Dataverse Connection
  • New: Implemented to create OAuth2 version 2.0 access tokens.
  • New: Support for FetchXml data retrieve.
  • New: Support for 'continue-on-error' data processing.
  • New: Support for Update/Upsert with alternate keys.
  • New: Support for Upsert using 'Duplicate Detection Rules' definition.
  • New: A new action parameter IgnoreNullValue to ignore NULL input values.
  • New: A new action parameter IgnoreMissingIdentifier to ignore missing lookup identifiers.
  • New: A new action parameter IgnoreUnchanged to avoid making updates where the input data is same as current.
  • New: 'listmembers' resource for list members maintenance.
Microsoft Graph Connection
  • New: Introduced connection.
OFTP Connection
  • New: Introduced connection.
Pardot Connection
  • New: Support for OAuth authentication.
Parquet Destination
  • New Introduced component.
Parquet Source
  • New: Introduced component.
PayPal Connection
  • New: Introduced connection.
PDF Source
  • New: Introduced component.
Power BI connection
  • New: Introduced connection.
PowerShell Task
  • New: Introduced task.
QuickBooks Online Connection
  • New: Introduced connection.
RabbitMQ Connection
  • New: Introduced connection.
REST Connection
  • New: WSDL Import.
  • New: A new feature to prepare the JavaScript expression for the Result element in the Read action by detecting common usage patterns.
  • New: A new feature to store authentication token in a database.
  • New: Support for client certificate configuration.
  • New: Enable retrieving API tokens within Microsoft Edge web browser component.
REST Destination
  • New: Support for multithreaded processing.
Sage 300 Connection
  • New: Introduced connection.
Sage Intacct Connection
  • New: Introduced connection.
Salesforce Connection
  • New: Updated web service proxy to version 54.
  • New: Support for Salesforce library files maintenance with File Transfer Task.
  • New: Parameters for Retry On Error.
Salesforce Source
  • New: Support for SOQL statements returning composite data.
SendGrid Connection
  • New: Updated 'Single Send' resource metadata as required. For further information, check here.
Shopify Connection
  • New: Support for 'Payout', 'Balance', 'Dispute', 'Transaction' resources.
Smartsheet Connection
  • New: Improved parameter entry.
SMTP Connection
  • New: Support for Google OAuth 2.0 authentication.
  • New: Support for Microsoft OAuth 2.0 authentication.
Stripe Connection
  • New: Introduced connection.
SugarCRM Connection
  • New: Introduced connection.
SuiteCRM Connection
  • New: Introduced connection.
SurveyMonkey Connection
  • New: Improved parameter entry.
Twilio Connection
  • New: Support for 'Message' resource.
Typeform Connection
  • New: Introduced connection.
XML Destination
  • New: Introduced component.
Zendesk Connection
  • New: Improved handling of custom fields in 'User' resource.
Zoho Sheet Connection
  • New: Introduced connection.
64-bit (x64) SQL Server 2012-2022
32-bit (x86) SQL Server 2012-2022
Development releases
Release Notes
64-bit (x64) SQL Server 2012-2022
32-bit (x86) SQL Server 2012-2022
Release Notes
64-bit (x64) SQL Server 2012-2019
32-bit (x86) SQL Server 2012-2019

SSIS+ 2.0

Release Notes

ActiveCampaign Connection
  • New: Introduced connection.
ADP Connection
  • New: Introduced connection.
Blackbaud Connection
  • New: Introduced connection.
ClickSend Connection
  • New: Introduced connection.
Close Connection
  • New: Introduced connection.
Copper Connection
  • New: Introduced connection.
Data Flow Task Plus
  • New: Support for Azure Flexible File Source and Destination components.
  • New: Context menu item "Remove Static Columns" when right-clicking on a component.
  • New: SSDT installation is no longer required during runtime.
Database Destination
  • New: Introduced component.
EDI Source
  • New: A new optional attribute segname for segment element in configuration file. If specified, the component will provide segment name information.
Elasticsearch Connection
  • New: Introduced connection.
Excel Destination
  • New: Ability to reference sheet by index (:index) when the sheet name is unknown.
Excel Source
  • New: Ability to reference sheet by index (:index) when the sheet name is unknown.
File Transfer Task
  • New: The result returned from 'Get remote files list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
FTPS Connection
  • New: Support for TLS 1.3.
Google BigQuery Connection
  • New: Support for service account authentication.
Google Drive Connection
  • New: Support for shared drives.
GoToWebinar Connection
  • New: Support for RFC 6749 compliant OAuth2 authentication.
  • New: Updated to GoToWebinar 2.0 REST API.
IMAP Connection
  • New: Support for TLS 1.3.
JSON Destination
  • New: Introduced component.
JSON Source
  • New: Introduced component.
Legacy Amazon S3 Task
  • New: The result returned from 'Get remote files list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
Linkedin Connection
  • New: Introduced connection.
monday connection
  • New: Introduced connection.
NetSuite Connection
  • New: Updated web service proxy to version v2019.2.
NetSuite Source
  • New: Support for join fields in a saved search.
  • New: Improved support for custom fields in a saved search (Thank you, Mauro).
OpenAir Connection
  • New: A new parameter ServerHost to support the new OpenAir service host requirement. The old ConnectionType parameter is no longer relevant and has been removed.
Pipedrive Connection
  • New: Introduced connection.
POP3 Connection
  • New: Support for TLS 1.3.
QuickBase Connection
  • New: Introduced connection.
QuickBooks Desktop Connection
  • New: Updated QuickBooks Online web service proxy to version 43.
  • New: A new parameter 'Start on Open' in QuickBooks Desktop Edition Gateway to automatically start the gateway when the application is opened.
  • New: Support for QuickBooks Online sandbox environment.
Receive Mail Task
  • New: The result returned from 'Get mail list' action can now be iterated using the standard 'Foreach ADO Enumerator'.
REST Connection
  • Breaking Change: Resource.Field.Default attribute has been removed from the configuration schema.
  • New: Enable retrieving API tokens within a modern Chromium-based web browser component (as an alternative to the IE-based one).
  • New: OpenAPI import.
  • New: Authentication template for Google User Account.
  • New: Authentication template for Google Service Account.
  • New: Authentication template for Amazon Web Services Signature v4.
  • New: Iterator template for OData services.
Sage Business Cloud Accounting Connection
  • New: Introduced connection.
Salesforce Connection
  • New: Updated web service proxy to version 48.
SendGrid Connection
  • New: Introduced connection.
SharePoint Connection
  • New: Experimental feature to explicitly specify authentication token when using MFA-enabled service. For further information please review 'Establish connection to MFA-enabled service' Quick Start.
  • New: Support for on-premises servers that use ADFS authentication.
SharePoint Destination
  • New: An enhanced configuration dialog with improved columns mapping page.
SharePoint Source
  • New: An enhanced configuration dialog with improved output columns page.
Shopify Connection
  • New: Support for cursor-based pagination process.
SMTP Connection
  • New: Support for TLS 1.3.
SSH Connection
  • New: If key-file authentication fails, the connection will attempt password-only authentication (Thank you, Pavel).
Table Difference
  • New: A new 'Diagnostic Log' output to analyze the differences on a more granular level.
Tableau Connection
  • New: Introduced connection.
Teamwork Connection
  • New: Introduced connection.
UiPath Connection
  • New: Introduced connection.
Xero Connection
  • New: Support for OAuth2 authentication.
YouTube Connection
  • New: Introduced connection.
64-bit (x64) SQL Server 2012-2019
32-bit (x86) SQL Server 2012-2019
Development releases
Release Notes
64-bit (x64) SQL Server 2012-2019
32-bit (x86) SQL Server 2012-2019
Release Notes
64-bit (x64) SQL Server 2012-2019
32-bit (x86) SQL Server 2012-2019

SSIS+ 1.9

Release Notes

Act-On Connection
  • New: Introduced connection.
Data Flow Task Plus
  • New: Support for ODBC Source and Oracle Source components.
EDI Connection
  • New: Introduced connection.
EDI Destination
  • New: Introduced component.
EDI Source
  • New: A custom editor to replace the basic one.
  • New: All previous configuration properties are now available in the new EDI Connection. This is the recommended way of configuring the component.
  • New: A new parameter InsertSequenceTerminator to support "composite records"-compatible formatting of output data.
Excel Connection
  • New: Support for Excel 2019.
  • New: A new parameter DateTimeFormat to specify string format when writing DateTime values.
Exchange Connection
  • New: Support for Exchange Online token-based authentication.
FTPS Connection
  • New: Support for Curve25519 elliptic curve algorithm.
HubSpot Connection
  • New: Support for 'Analytics', 'Association', 'Ticket', 'Product', 'Line Item', 'CRM Object Property' resources.
JavaScript Component
  • New: Introduced component.
JavaScript Task
  • New: Introduced task.
KRONOS Connection
  • New: Introduced connection.
Legacy Amazon S3 Connection
  • New: Support for Signature 4 protocol.
Lookup
  • New: Basic clipboard cut/copy/paste operations for use in lookups definition grid.
Microsoft Dataverse Connection
  • New: Introduced connection.
NetSuite Connection
  • New: Updated web service proxy to version v2018.2.
  • New: Support for token-based authentication.
Package Connection
  • New: Support for packages stored in Integration Services (SSISDB) Catalog
Pardot Connection
  • New: Support for reading from 'Email', 'Email Stats' resources.
  • New: Authentication now placed in request header as required by service.
PureCloud Connection
  • New: Introduced connection.
QuickBooks Desktop Connection
  • New: Support for QuickBooks Online OAuth 2.0 authentication.
  • New: Updated QuickBooks Desktop web service proxy to version 13.
  • New: A new parameter QBXMLVersion for use with QuickBooks Desktop connections.
  • Fixed: Failed with error when using 'ItemSites' object (Thank you, Joel).
REST Connection
  • New: Ability to author configurations to arbitrary REST services.
  • New: Slight modifications in the RCM configuration format for improved consistency.
  • New: Getting Help now opens a more relevant documentation page (depending on the selected configuration and current tab).
  • New: Included option to tweak user agent of web browser used in 'New Token' wizard dialog.
REST Destination
  • New: Usability improvements in the UI for managing parameters.
REST Source
  • New: A new parameter Endpoint to explicitly specify the endpoint used for data retrieval.
  • New: Usability improvements in the UI for managing parameters.
  • New: A design-time log, accessible via a new 'View Log' button (for troubleshooting purposes).
  • New: Enhancements in the logging output.
Sailthru Connection
  • New: Introduced connection.
Salesforce Connection
  • New: Updated web service proxy to version 45.
Salesforce Source
  • New: Improved the metadata initialization when using SOQL statements (no more missing columns if the result contains empty fields).
  • New: Support for Bulk mode for SOQL statements.
  • Fixed: The "Preview" failed with "EXCEEDED_ID_LIMIT" error under some conditions.
Shopify Connection
  • New: Support for 'Inventory Item', 'Inventory Level', 'Inventory Location' resources.
Sisense Connection
  • New: Introduced connection.
SMTP Connection
  • New: A new parameter Pipelining.
  • New: A new parameter Chunking.
Sort Plus
  • New: Introduced component.
SSH Connection
  • New: A new parameter Compression.
  • New: Included support for Curve25519 elliptic curve algorithm.
WordPress Connection
  • New: Introduced connection.
Zoho CRM Connection
  • New: Included configuration for v2 API.
Zuora Connection
  • New: Support for ZOQL statements.
64-bit (x64) SQL Server 2005-2019
32-bit (x86) SQL Server 2005-2019
Development releases
Release Notes
64-bit (x64) SQL Server 2005-2019
32-bit (x86) SQL Server 2005-2019
Release Notes
64-bit (x64) SQL Server 2005-2019
32-bit (x86) SQL Server 2005-2019
Release Notes
64-bit (x64) SQL Server 2005-2019
32-bit (x86) SQL Server 2005-2019

SSIS+ 1.8

Release Notes
64-bit (x64) SQL Server 2005-2017
32-bit (x86) SQL Server 2005-2017
Release Notes
64-bit (x64) SQL Server 2005-2017
32-bit (x86) SQL Server 2005-2017
Release Notes
64-bit (x64) SQL Server 2005-2017
32-bit (x86) SQL Server 2005-2017
Release Notes
64-bit (x64) SQL Server 2005-2017
32-bit (x86) SQL Server 2005-2017

SSIS+ 1.7

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 Server 2012, SQL Server 2014, or SQL Server 2016.
Release Notes
64-bit (x64) SQL Server 2005-2016
32-bit (x86) SQL Server 2005-2016
Release Notes
64-bit (x64) SQL Server 2005-2016
32-bit (x86) SQL Server 2005-2016
Release Notes
64-bit (x64) SQL Server 2005-2016
32-bit (x86) SQL Server 2005-2016
Release Notes
64-bit (x64) SQL Server 2005 - 2016
32-bit (x86) SQL Server 2005 - 2016

SSIS+ 1.6

Release Notes
Release Notes
Release Notes
Release Notes
Release Notes

SSIS+ 1.5

Release Notes
Release Notes
Release Notes
Release Notes
Release Notes

SSIS+ 1.4

Release Notes
Release Notes
Release Notes
Release Notes
Release Notes

SSIS+ 1.3

Release Notes
Release Notes
Release Notes
Release Notes
Release Notes
Release Notes

Older Releases

Looking for SSIS+ 1.2 or older release? Contact us.

Release Notes

Sunday, November 3, 2019 - 13:00

SSIS is Microsoft's premier enterprise-grade ETL platform. Over the years it has gained a huge market share due to its reliability, excellent performance and the availability of third-party addons that enable connecting to a plethora of systems and applications. But SSIS has one major limitation, being primarily a scheduled, batch processing system. Out of the box, it doesn't support event-triggered data and application integration. To be able to support near real-time data processing, companies are forced to either use workarounds or look outside SSIS. So far, the following options have been available:

  • Schedule SSIS package execution often, the unfortunate result being increased resource use if there is no data to be processed.
  • Use other systems like BizTalk to handle the external events.
  • Implement non-trivial custom solutions for a bridge that could initiate processing based on an event.

COZYROC is happy to introduce SSIS NoW technology that aims to fill this gap and make it easy to support event-triggered execution for near real-time data processing. Its key features include:

  • Support for webhooks and the ability to use other trigger APIs.
  • Reliable events handling with the use of message queuing technology.
  • Scalable, distributed package execution for handling a large number of events.
  • "Warm-start" package execution for optimal performance.

We believe this new technology increases SSIS platform capabilities even further. SSIS NoW is immediately available for use by all COZYROC SSIS+ Ultimate subscription customers. There is no additional cost to be paid.

To find more details about the SSIS NoW technology, please visit the page here. Feel free to contact us and provide your feedback.

We have one announcement to make:

  • Starting on December 1st, 2019 the cost of one SSIS+ Ultimate subscription will be $799/year for new subscriptions. The price for existing subscribers stays the same, as long as their subscriptions are kept current.
Buy Now before the new price becomes effective

The COZYROC Team

64-bit (x64) SQL Server 2012-2022
32-bit (x86) SQL Server 2012-2022
Development releases