1.9.1.647

  • New: Support for Zoho CRM v2 API.
  • New: JavaScript Component display of "Mappings" tab is controlled in the script
  • New: JavaScript Component now shows a readonly metadata report ("Input columns" and "Inputs and Outputs" are retired)
  • New: Support for afterEdit for JavaScript parameters
  • New: Helper methods for JavaScript Component in component.metadata.js
  • New: More declarative JavaScript validation via built-in functions like validation.required (breaking change)

1.9.1.602

  • New: EDI Connection
  • New: EDI Destination

1.9.1.591

  • New: JavaScript Task.
  • New: JavaScript Component.

JavaScript Component

Overview

JavaScript Component

JavaScript Component enables automating of any custom logic in the data flow. It is an alternative of Microsoft Script Component and COZYROC Script Component Plus. You might also consider using it instead of Microsoft Derived Column Transformation if you need to deal with more complex expressions.

1.9.1.539

  • New: Support for SQL Server 2019

1.9.1.504

  • New: Support for NetSuite token-based authentication.

Sort Plus

Overview

Sort
The Sort Plus Component is an SSIS Data Flow asynchronous transformation component, which is capable of sorting very large amounts of data. It uses a sophisticated proprietary algorithm that employs smart chunking and caching of data on disk. It enables an optimal utilization of your server's resources, by doing all processing in parallel, using a configurable number of threads.