Wednesday, February 14, 2024 - 06:55
COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 2.2 library. The new version includes support for 37 additional applications. We have introduced a new Derived Column transformation component, a powerful replacement of the standard Derived Column transformation with support of expressions in JavaScript. The COZYROC REST framework has been further improved with support for GraphQL and OData APIs.
The COZYROC Team
Summary of the products available immediately for purchase:
- SSIS+ Ultimate Subscription at $1199/Year.
- SSIS+ 2.2 perpetual license at $7,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 Visual Studio 2022.
- 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.