Saturday, September 5, 2020 - 12:00
COZYROC has the pleasure to announce the official release of the COZYROC SSIS+ 2.0 library. The new version includes major improvements in usability during design time. With the addition of Database Destination (for easy Upserts and fast DB loads), COZYROC SSIS+ now offers the most powerful toolbox for developing data warehousing solutions (see also Table Difference, Lookup Plus and Sort components). The COZYROC REST framework has been further refined and you can now access, directly from Visual Studio, a rapidly growing library of pre-built templates/accelerators for consuming numerous popular third-party web APIs (currently 40+ services).
The COZYROC Team
Summary of the products available immediately for purchase:
- SSIS+ Ultimate Subscription at $899/Year.
- SSIS+ 2.0 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: Destination components now have the ability to preserve existing columns mapping.
- New: Ability to access data flow component properties expression without leaving the dialog.
- New: Vastly improved destination component columns mapping with fine-grained filtering.
- New: Ability to select a prebuilt template as a starting point for your REST configuration efforts.
- New: Available reusable JavaScript scripts are now easy to access directly from Visual Studio.
- New: COZYROC components group in the SSIS Toolbox for convenience.
- New: The library is no longer dependent on certain SSIS design-time components.
- New: An enhanced dialog for FLEE expression definition.
- Fixed: Failed with error "Field 'CozyRoc.SqlServer.SSIS.DataFlowSource.m_destination' not found." when using COZYROC Data Flow Source component (Thank you, Arun).
- Fixed: Output column error and truncation row disposition were not configured for most source components (Thank you, Dan).
- Fixed: Failed with error "Invalid value at 'report_requests[0].page_token' (TYPE_STRING), 200" when reading Report resource (Thank you, Cameron).
- Fixed: Only first 10000 rows read from
Queryresource (Thank you, Sebastian). - Fixed: Data retrieved for
Queryresource was not populated in the correct columns (Thank you, Patrick). - Fixed: Data retrieved for
Tabledataresource was not populated in the correct columns (Thank you, Angel).
- Fixed: Update action failed with error "A value in the request is invalid." (Thank you, Doug).
- Fixed: Failed with error "Column data type DT_STR is not supported by the PipelineBuffer class" when trying to process input columns of type DT_STR (Thank you, Megha).
- New: Ability to specify special characters in On NULL and No Match definitions.
- Fixed: Only 10 merge fields appeared in 'List Member' resource (Thank you, Jo).
- Fixed: Inserting data into 'List Member' resource failed with error "Index was outside the bounds of the array" when service reported error (Thank you, Steve).
- Fixed: Failed to update data in 'List Member' resource (Thank you, Steve).
- Fixed: Failed with error "Command 'listCollections' failed: command not found..." when using MongoDB Atlas (Thank you, Raphael).
- New: Add a custom editor for improved design-time experience.
- New: Improved support for UUID data.
- Fixed: Failed to link to script when using SSDT for Visual Studio 2015 (Thank you, Shaikshavali).
- Fixed: Failed with error "Array attributes may not contain null elements: row.cells[]." when updating sheet data (Thank you, Cesar).
