Sunday, August 8, 2021 - 13:00
Released COZYROC SSIS+ 2.0 SR-1 (2.0.101.2334). The release includes the following major changes:
- Fixed: FLEE expressions are now parsed using invariant culture.
- New: Support for Event API resources.
- New: Support for NXT Data Integration API.
- Fixed: Various fixes (Thank you, Brian).
- New: 'OLE DB Command' transformation can now reference static columns in a dynamic flow.
- Fixed: Failed with error "Object reference not set to an instance of an object" under specific conditions (Thank you, Ryan).
- New: Enhanced input columns mapping and configuration (Thank you, Mika).
- Fixed: Failed with error "Invalid object name 'SYS.OBJECTS'" when using a case-sensitive database (Thank you, Annette).
- Fixed: Insert failed in the temporary table with identity column (Thank you, David).
- Fixed: Failed with error "Incorrect syntax near the keyword 'MERGE'" on machines with older driver (Thank you, Josh).
- Fixed: Destination table columns are no longer alphabetically sorted when initialized (Thank you, Mika).
- Fixed: Columns refresh overview displayed incorrect information (Thank you, Geoff).
- Fixed: Failed with error "System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary." when trying to process a destination table found in a schema different from
dboschema (Thank you, Ayman). - New: Improved handling of columns of type datetime2 when using OLE DB driver (Thank you, Damien).
- New: A new parameter TempSchema to configure the schema for the used temporary tables.
- New: Improved error diagnostic information when using DB2 database (Thank you, Mika).
- Fixed: Failed to initialize the default value for columns of type BIT in MySQL (Thank you, Sundar).
- Fixed: Errors when destination SQL Server table contains UDT columns (Thank you, Alain).
- New: A new OrganizationUrl parameter for setting organization service address. When specified, the discovery service is not used.
- Fixed: Unable to access files on shared drives (Thank you, Steve).
- Fixed: Failed with error "Maximum number of named properties reached." when a folder contains more than 16000 files (Thank you, Dave).
- New: Support for shared drives.
- Fixed: Failed with error "Maximum number of named properties reached." when a folder contains more than 16000 files (Thank you, Dave).
- Fixed: Failed to process input columns of type
DT_CY(Thank you, Gerald). - Fixed: Modified to preserve the order of the columns from the input.
- New: A new parameter Format with a choice to create regular JSON files or files in JSON Lines format.
- New: A new parameter Skip NULLs to avoid including elements that are NULL.
- New: A new parameter Format with a choice to process regular JSON files or files in JSON Lines format.
- New: Client Id and Client Secret are now configurable for the generated access token.
- New: Modified to use HMAC-SHA256 signature algorithm for token-based authentication.
- Fixed: Component failed with error "System.MissingMethodException: Method 'CozyRoc.NetSuite.Service.AccountingPeriodSearchRowBasic.customFieldList' not found." (Thank you, Nick).
- Fixed: Failed to process a "Saved Search" that uses custom fields (Thank you, Andrei).
- Fixed: Infinite loop when trying to retrieve data from 'System | Table' resource (Thank you, Dean).
- Fixed: Modified to use Windows-1252 encoding for handling data returned by the service (Thank you, Dean).
- Fixed: 'Get mail list' action failed when using with Exchange connection (Thank you, Cesar).
- Fixed: 'Get mail list' action failed when using with POP3 connection (Thank you, Marvin).
- Fixed: Incorrect AWS v4 signature generation for requests with
GetOrPostparameters (Thank you, Joyce).
- New: In case of an error when reading data in bulk, the component will retry.
- New: Included command to close job after the bulk read is complete.
- Fixed: Modified to use Export API for 'Contact' resource because the previously used API no longer supports pagination.
- New: Introduced parameters for specifying client id/secret during the authentication token generation.