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.
ArcGIS Feature Connection
  • Fixed: Various fixes.
Dropbox Connection
  • Fixed: Failed to retrieve files from the root folder.
Dynamics CRM Destination
  • Fixed: Component was not detecting boolean input values properly because of a different case when IgnoreUnchanged parameter was set to True.
File Transfer Task
  • Fixed: Local file modified time was incorrectly set to the remote file modified time when the local file exists and OverwriteLocal parameter was set to False.
Google Admin Connection
  • Fixed: Fixes in 'Member' resource.
Google Drive Connection
  • Fixed: Failed with error "Invalid field selection fileId" when reading from Permission resource (Thank you, Karen).
Lookup
  • Fixed: Dialog was cancelled even when user has explicitly set not to cancel.
ODBC Destination
  • Fixed: Component didn't process the milliseconds of timestamp columns properly (Thank you, Irawan).
Pardot Connection
  • Fixed: The definition for result extraction was incorrect.
SharePoint Connection
  • Fixed: File Transfer Task was not working properly because of different file name case.
  • Fixed: File Transfer Task 'Create Remote Directory', 'Remove Remote Files', 'Rename Remote File' actions did not work properly when used with SharePoint sub-site.
  • Fixed: File Transfer Task did not report failure errors.