Thursday, May 3, 2018 - 14:15
COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 1.8 library. In addition to the availability of many new connectors, we have invested extra effort in the overall polish of the toolkit. A new build and release process was also implemented and you will soon see improvements in both the availability and frequency of development releases and higher quality official releases. We have two announcements to make:
- Version 1.8 will be the last version with support for SQL Server 2005 and 2008. We hope this will provide enough time to our customers to make the transition to newer and greater SQL Server versions.
- Starting on June 1st, 2018 the cost of one SSIS+ Ultimate subscription becomes $479/year for new subscriptions. The price for existing subscribers stays the same, as long as their subscriptions are kept current.
Thank you for investing your hard-earned dollars in our products! Your investment is in safe hands and we will not disappoint you!
The COZYROC Team
Summary of the products available immediately for purchase:
- SSIS+ Ultimate Subscription at $399.95/Year. Starting on June 1st, 2018 the price becomes $479/year.
- SSIS+ 1.8 perpetual license at $3,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 2017.
- New: Support for SSDT for Visual Studio 2017.
- New: Support for Azure ADFv2 deployment.
- Fixed: Fixes for handling incorrect metadata setup by ADO.NET Destination component.
- Fixed: AutoAdjustBufferSize property was not available for SQL Server 2016 (Thank you, Adam).
- Fixed: Failed to process destination tables with columns having greater than 4000 characters but less than 8000 (Thank you, Matt).
- Fixed: Failed to process when using Fuzzy Lookup component (Thank you, Matt).
- New: Setup a more appropriate DT_DBDATE column data type for attributes with DateTimeFormat.DateOnly setting.
- New: Setup includes the unique name of the selected organization.
- New: Access Control Service (ACS) is no longer used to connect to Dynamics 365/CRM Online.
- Fixed: Type attributes for Customer fields were not handled correctly (Thank you, Siraj).
- Fixed: Various fixes related to the IgnoreUnchanged option (Thank you, Mihkel).
- Fixed: Dialog opening generated error when using older SSIS packages (Thank you, Senthil).
- Fixed: Component didn't handle type attributes for Customer fields correctly (Thank you, Siraj).
- Fixed: Component incorrectly converted input UTC datetime columns to local time. This broke backwards compatibility for existing packages (Thank you, Saritha).
- New: Component setup dialog now includes data Preview tab.
- Fixed: Component didn't handle type attributes for Customer fields correctly (Thank you, Siraj).
- New: Component can now read from named ranges pointing to tables.
- Fixed: Component failed with error when input cell value was larger than the output column length and the column truncation metadata was set to ignore (Thank you, Dave). For further information check this post.
- Breaking Change: Newline delimited result returned by 'Get remote files list' action now contains full-path names when ExtendedRemoteFileInfo is False.
- Fixed: Failed with error "Ephemeral Diffie-Hellman prime received from the server is considered weak" (Thank you, Michael).
- Fixed: File Transfer Task failed with error "The requested operation is not supported" (Thank you, Dave).
- New: Support for OAuth 2.0 authentication.
- New: Support for add/remove of contacts in list.
- Fixed: REST Source component failed with error (Thank you, Paul):
"Template: {{=external.rest.name=='id'}}
Field: undefined
Value: undefined
Error: TypeError: undefined cannot be converted to an object"
- Fixed: Component inserted mangled text when using MySQL database as destination (Thank you, Lokeswar).
- Fixed: Component failed to insert data into a table where column names contained space (Thank you, Valeriu).
- Fixed: Failed when project connections were used.
- Fixed: Resolved long-standing concurrency issue affecting customers using SQL Server 2012 and above. The issue appeared occasionally when a connection expression was configured to use a variable iterated in the loop.
- Fixed: Component failed with error "System.Exception: Unhandled type: QvxQvSpecialFlag (0)" (Thank you, Fathima).
- Fixed: Failed to generate new token for the latest QuickBooks Online service.
- Fixed: IgnoreNullValue parameter didn't work properly when bulk-mode was used.
- Fixed: Component failed with error "type must be specified for polymorphic foreign key field: Who" (Thank you, Mustafa).
- New: A new parameter BulkJobInfo for optional bulk job information.
- Fixed: Component failed with error 'Index was outside the bounds of the array." during initialization when having more than one component executing simultaneously (Thank you, Sam).
- Fixed: Failed to connect to SharePoint Online when third-party Ping token service was used (Thank you, Pradeep).
- Fixed: File Transfer Task was not working properly when used with SharePoint sub-site (Thank you, Michael).
- New: Component now provides better diagnostic information when required third-party modules are not properly deployed.
- New: Support for newer Tableau SDK modules.
- New: Support for Tableau 10.5 Hyper.
- Fixed: BZip2 file compression failed with error 'Cannot access a closed File.' (Thank you, Krish).
- Fixed: Zip decompression failed with error "CRC mismatch" when processing certain files created with ComponentOne library (Thank you, Anders).
