Version 3.0 - February 21, 2019

This release comes with the following updates and enhancements:

  • New: We have added support for SSIS 2019.
  • New: For lookup and dropdown list fields, we now return two fields instead of 1 in previous releases. The two fields include the original label value field, plus one more field ending with "_id" which would return the lookup ID value. 
  • New: Custom list fields in advanced searches can now be output as the name or id of the value in Source.
  • New: Advanced search now supports Join fields.
  • New: Custom list fields names can now be used in destination, and IDs will be retrieved with a lookup.
  • Enhancement: Various UI enhancements and performance improvements.
  • Fixed: When using Saved Search in NetSuite source component, lookup fields always return NULL values, even there might be values in the system.
  • Fixed: When using Saved Search in NetSuite source component, dropdown list field always returns NULL values, even there might be values in the system. 
  • Deprecation: We removed support for SQL Server 2005.

Version 2.1 - August 17, 2018

This release comes with the following updates and enhancements:

  • New: We added support for Token Based authentication in NetSuite connection manager. 
  • New: We added support for NetSuite SOAP file version 2018_1.
  • Update:  NetSuite components now automatically detect the data center of the specified account to discover the correct URL to access your NetSuite account.
  • Enhancement: We improved the error handling in NetSuite Connection Manager when test connection failed.
  • Enhancement: We have updated the license manager program to now report details of distinct connections in use.
  • Fixed: Our software may report a connection metering related error during runtime for some specific system environments.
  • Fixed: NetSuite Source component may not escape the quote and single quote characters properly when saving the search query.
  • Fixed: Secondary error output in NetSuite Destination component may report incorrect failed rows.
  • Fixed: NetSuite Destination component may send "0001-01-01T00:00:00" for input NULL datetime values.

Version 2.0 - March 14, 2018

This release comes with the following updates and enhancements:

  • New: NetSuite Source component now returns internalId values for referenced objects when reading from NetSuite custom objects.
  • New: We added support for Azure-SSIS Integration Runtime (IR) deployment and licensing.
  • New: Standard use licensing model, this limits the number of distinct connections to 8 per connection type within a 24 hour period at runtime.
  • Update: We have an updated version of License Agreement that covers the new Azure-SSIS IR licensing model along with many other revisions - the new agreement becomes effective as of today (April 26, 2018).
  • Fixed: You may get error "Object reference not set to an instance of an object" error when passing a null value to the id field for Delete action.
  • Fixed: Some UI bug fixes for NetSuit Destination component.

Version 1.2 - December 14, 2017

This release comes with the following updates and enhancements:

  • New: NetSuite Source component now supports detecting custom fields and joined fields in Saved Search.
  • New: We added support of detecting custom fields for child objects.
  • Fixed: NetSuite Destination component did not handle NULL values correctly.
  • Fixed: No records retrieved when reading from custom Saved Search using NetSuite Source component.
  • Fixed: Field internalid was not populated for custom objects in NetSuite components.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 1.1 - October 6, 2017

This release comes with the following updates and enhancements:

  • New: We added a documentation generation button to all SSIS components that can be used to generate a Word document which describes the component's metadata including relevant mapping, and so on.
  • New: We added support for NetSuite SOAP file version 2017_1.
  • New: We added support for custom fields on child objects.
  • New: Connections to NetSuite are now made with the latest and greatest TLS protocol whenever possible.
  • Enhancement: Performance enhancement when loading a large number of columns at design time in NetSuite Destination component.
  • Fixed: Autodetect Custom Field always read all records instead of reading the specified number of records.
  • Update: Some updates to the licensing component.

Version 1.0 - July 7, 2017

This is our first public final release of SSIS Integration Toolkit for NetSuite software.

  • Three main components
    • NetSuite Connection Manager
    • NetSuite Source Component
    • NetSuite Destination Component
  • Support for SSIS 2017, 2016, 2014, 2012, 2008R2, 2008, or 2005
  • Support for the following four actions in NetSuite Destination Component
    • Create
    • Update
    • Upsert
    • Delete