COZYROC SSIS+ 1.9 now officially released

Monday, July 1, 2019 - 13:00

COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 1.9 library. We are very excited about the possibilities this new version provides to our customers for easier connectivity to any REST service. The other major highlight of the 1.9 release is the support for JavaScript scripting, which can dramatically simplify the implementation of custom parts in a solution by enabling a rapid development of reusable, easily-configurable components and tasks.

Those new capabilities, not available in any other product on the market, further increase the value of our SSIS+ suite, which is well-known for bringing major innovations to SSIS customers with the support of dynamic data flows, composite records modelling, etc. By choosing COZYROC SSIS+ 1.9 you can rest assured you are purchasing the most advanced technology on the market for solving even the most challenging problems in your integration projects. And the best part is that we still offer the most affordable subscription for a fully-fledged SSIS suite of tasks and components. Cheers!

We have two announcements to make:

  • Support for SQL Server 2005 and 2008 is still included. The support for these older SQL Server versions is planned for removal in the next major version. Please note the 2008 binaries now target .NET Framework 3.5 instead of .NET 2.0.
  • The cost of the SSIS+ 1.9 perpetual license has been increased to $4,999 per license.

The COZYROC Team

Click here to download the COZYROC SSIS+ 1.9 Suite

Summary of the products available immediately for purchase:

  • SSIS+ Ultimate Subscription at $699/Year.
  • SSIS+ 1.9 perpetual license at $4,999
  • SAS® Adapters license at $2,499.95
  • USPS Address Database / One time purchase at $299.95
  • USPS Address Database / Monthly Subscription at $2,399.95/Year
  • SSIS+ Premium Support at $499.95/Year

For more information, check the purchase page.

Summary of the new / updated components

  • New: Support for SQL Server 2019.
  • New: Support for SSDT for Visual Studio 2019.
  • Improved: High-DPI scaling for high-resolution monitors.
AMQP Connection
  • New: Enabled Support for TLS 1.1 and 1.2.
Copper Connection
  • New: Configure array for parameters with suffix _ids.
Dynamics Business Central Connection
  • Fixed: Failed with error "undefined cannot be converted to an object" when trying to Create/Update entity records (Thank you, Abdelhadi).
  • New: Support for navigation properties.
Excel Source
  • Fixed: Processing of columns with type different from string failed for cultures that are not invariant (Thank you, John).
File Transfer Task
  • Fixed: Specifying only wildcard for the Remote parameter (no folder) caused failure when using 'Receive Action' (Thank you, Mark).
Google Drive Connection
  • New: Error when browsing a folder containing items with double quote (") characters (Thank you, Rob).
JSON Destination
  • New: Failed to process when used in a dynamic data flow.
  • New: Support for data streaming.
Kafka Connection
  • New: Additional SSL parameters.
  • New: Logging options.
KRONOS Connection
  • New: Defined hr_customFields and pay_info fields under Employee resource.
LDAP Destination
  • New: Support for object rename.
  • New: Support for setting user passwords.
  • New: Improved error reporting.
Microsoft Dataverse Connection
  • Fixed: Field's metadata was not updated after FetchXml parameter modification (Thank you, Paul).
Microsoft Graph Connection
  • New: Improved handling of SharePoint list lookup fields (Thank you, Eric).
  • New: Included definitions to retrieve Drive in Site/User/Group resources (Thank you, Drew).
  • New: Support for delta endpoint in Message resource.
  • Breaking Change: Modified 'Site | List Item' resource to configure more user-friendly column names.
OpenAir Connection
  • New: Included UserWorkschedule type.
Parallel Loop Task
  • Fixed: Failed with error "The object cannot be added because another object with the same name already exists in the collection. Use a different name to resolve this error." when executing parent -> child package with duplicate parameters in both packages (Thank you, Manuel).
Parquet Destination
  • Fixed: Incorrect lower-case headers (Thank you, Romain).
  • Fixed: Missing record in each batch of records (Thank you, Romain).
Parquet Source
  • Fixed: Incorrect lower-case headers (Thank you, Romain).
  • Fixed: Failed with error "System.IO.EndOfStreamException: Unable to read beyond the end of the stream." (Thank you, Naveen).
  • New: Considerable performance improvements.
  • Fixed: Data mismatch when reading from certain files (Thank you, Jessica).
PDF Source
  • New: A new parameter 'Skip incomplete data rows'.
  • New: Find table by index, regex or both. (replace TableIndex with TableFindBy and TableFind)
Power BI connection
  • Fixed: tenant parameter was not used during OAuth token generation.
  • Fixed: Various fixes and enhancements (Thank you, Pat).
QuickBooks Desktop Connection
  • New: Support for TLS 1.1 and 1.2 protocols in QuickBooks Desktop Edition Gateway.
RabbitMQ Connection
  • Fixed: Package unable to finish execution when the package is deployed in 'SSIS Catalog' (Thank you, Victor).
REST Destination
  • New: Performance improvement in multithread processing.
Sage Intacct Connection
  • New: Improved response processing performance.
  • Fixed: Incorrect caching of all object relationship fields, instead of only loading from the list selected in relationshipFields parameter. (Thank you, James).
  • New: Support for create_sotransaction action.
  • New: 'Attachment Legacy' resource.
Salesforce Source
  • Fixed: Got NULL when an output column name differs from an external column name. (Thank you, Lucas)
  • Fixed: Failed with error "System.ObjectDisposedException: Cannot access a disposed object." when reading data in bulk. (Thank you, Venkat)
Shopify Connection
  • Fixed: Two resources having the same Transaction name.
  • New: Replaced deprecated 'Discount' resource with the new 'Discount | Price Rule' and 'Discount | Discount Code' resources.
Smartsheet Connection
  • Fixed: Failed to generate authentication token using Edge browser (Thank you, Gbade).
SSH Connection
  • Fixed: A regresion with "Access denied" error when trying to upload a file on certain servers (Thank you, Tyler).
  • New: Support for file permissions update using File Transfer Task AdditionalOptions parameter.
XML Destination
  • New: Support for external XSD references when initializing the document model.
  • New: Improved support for namespaces, self-referencing elements, attribute group references and simple type restrictions.
  • Fixed: Attributes namespaces.
  • Fixed: Incorrect default scale for decimal fields.
  • New: Support for data streaming.
Zendesk Connection
  • New: Included cursor pagination for Ticket and User resources.
Zip Task
  • New: Support for Deflate64 algorithm in decompression.
Zuora Connection