Friday, February 23, 2018 - 12:00
Released COZYROC SSIS+ 1.7 SR-1 (1.7.101.0). The release includes the following major changes:
- Fixed: Using project connections in tasks failed with error "The connection "..." is not found" (Thank you, Arun).
- 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.
- 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: 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).
