Version 4.0 - October 3, 2019

This release comes with the following updates and enhancements:

  • New: We added support for NetSuite SOAP file version 2019_1.
  • New: NetSuite Source component now supports retrieving Saved Search without enabling Advanced option, which can be used to get full records result when executing a saved search.
  • New: We added an option called "Override Search Columns" in NetSuite Source component, which can be used to override existing search
    return columns with new search return columns when using saved search with Advanced option enabled.
  • New: NetSuite Source component now supports retrieving a list of all records of the specified type by utilizing NetSuite Web Service getAll Operation. The following objects are added in NetSuite Source componnet: BudgetCategory, CampaignAudience, CampaignCategory, CampaignChannel, CampaignFamily, CampaignOffer, CampaignSearchEngine, CampaignSubscription, CampaignVertical, Currency, LeadSource, State, SupportCaseIssue, SupportCaseOrigin, SupportCasePriority, SupportCaseStatus, SupportCaseType, TaxAcct.
  • New: We added pagination support in NetSuite custom fields auto-detection by specifying page size and number of pages.
  • New: We added Import/Export custom fields ability to NetSuite Source and Destination components.
  • Enhancement: Better custom fields detection for joined fields in Saved Search.
  • Enhancement: Custom fields are retained in NetSuite Source/Destination component when refreshing the component.
  • Enhancement: Improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.
  • Enhancement: There are some updates to the License Manager program that provide better tracking of license installation and easier license management by our client services team.

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