COZYROC SSIS+ 2.0 now officially released

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

Click here to download the COZYROC SSIS+ 2.0 Suite

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.

Asana Connection

Fixed: Various fixes and improvements (Thank you, Stewart).

Constant Contact Connection

Fixed: Failed with error "Invalid Pagination parameters: If 'next' is provided, no other parameters may be present." (Thank you, Dinesh).

Data Flow Task Plus

Fixed: Failed with error "A truncation error occurred on the specified object of the specified component." when using COZYROC Excel Source component (Thank you, Jason).

Dynamics NAV Connection

New: Enabled support for TLS 1.1 and 1.2 protocols.

Google Analytics Connection

New: Updated to use new OAuth2 2.0 authorization addresses.

Google BigQuery Connection

New: Updated to use new OAuth2 2.0 authorization addresses.

Google Drive Connection

New: Updated to use new OAuth2 2.0 authorization addresses.

Google Sheets Connection

New: Updated to use new OAuth2 2.0 authorization addresses.

HubSpot Connection

Fixed: Various fixes and enhancements.
Fixed: Infinite loop when trying to retrieve data from 'Contact' resource (Thank you, Geoff).

JavaScript Component

Fixed: Visual Studio crash after initial script selection.

KRONOS Connection

Fixed: Defined identifier field type was not large enough.

Mailchimp Connection

Fixed: Missing user-defined parameters from Create and Update actions.
New: Support for address merge fields (Thank you, Hardy).

PureCloud Connection

Fixed: Failed to retrieve all data from 'User Status Detail Query' resource (Thank you, Henrik).
Fixed: Included definition for missing fields in 'Conversation Detail Query' resource.

QuickBooks Destination

Fixed: Failed to create metadata for 'JournalEntry' object (Thank you, Chris).

REST Source

Fixed: Available endpoints didn't update after definition of 'Extended Metadata'.

Sage Connection

Fixed: Various fixes (Thank you, Adam).

Salesforce Source

Fixed: Id fields from related objects missing (Thank you, Ranjan).
Fixed: Metadata of certain related fields was not configured.
Fixed: Failed with error 'Unhandled type: urnRecordTypesSupported' (Thank you, Allen).

Smartsheet Connection

Fixed: clear parameter was not handled properly in 'Sheet Data' resource Create/Update action (Thank you, Kwame).

Sort Plus

Fixed: Crash with error "System.ArgumentException at System.Collections.Generic.IntrospectiveSortUtilities.ThrowOrIgnoreBadComparer..." (Thank you, John).