What's New

SSIS Integration Toolkit for Microsoft Dynamics GP

Detailed changelog for every release of the Microsoft Dynamics GP Integration Toolkit

Version 24.1 - June 12, 2024

The following are the updates and enhancements made for each group of components:

  • New: We added support for Dynamics GP 2022.
  • Update: We have updated GP connection manager to use a higher connection timeout and command timeout setting by default.
  • Update: We have introduced a newly designed exception message window for better usability.
  • Enhancement: Some additional DPI display optimizations to various forms.

Version 23.2 - September 7, 2023

  • Enhancement: We have some updates to the License Manager program UI to make it more responsive to changes made to the license installation in the background.
  • Update: We have removed SSIS 2008 (Including SQL Server 2008 R2) support.

Version 23.1 - March 17, 2023

This release comes with the following updates - Note that this will be our last version that supports SSIS 2008 (SQL Server 2008):

  • Update: The auto-update form now displays a warning message about required maintenance for software upgrade.
  • Update: We have removed the dependency on Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll assembly.
  • Fixed: KingswaySoft License Manager might report an incorrect grace period when the license is running under the grace terms.
  • Some other general updates.

Version 22.1 - October 19, 2022

This release comes with the following updates :

  • New: We have added support for SQL Server 2022 (SSIS 2022).
  • Enhancement: We have updated the license manager program to make it more resilient in obtaining new license files or renewals should there be intermittent networking issues. The enhancement mainly applies to unattended license requests or updates using command line via Windows script, it is particularly helpful when you run our software on Azure SSIS IR as it involves license activation requests each time when the instance is started or restarted.
  • Update: The entire program has received some major branding updates in various UI elements.
  • Fixed: GP Destination component may not release connection properly upon the execution completion.

Version 21.2 - November 11, 2021

This release comes with the following updates:

  • New: We added a new action button in the KingswaySoft License Manager which makes it easy to request a free trial.

Version 21.1 - May 28, 2021

This release comes with the following updates:

  • New: Dynamics GP NextDocNumber component now supports generating the next UPR Check number.
  • New: We now ship a new console version of KingswaySoft License Manager program which is designed to work more reliably in a container environment.
  • New: KingswaySoft License Manager program now always uses a secure service endpoint for activation and deactivation requests.

Version 20.2 - November 4, 2020

This release comes with the following updates:

  • New: KingswaySoft License Manager now includes the ability to show and copy the LicenseId within the program which can be used for renewal purposes without having to reveal the full license key details, for instance, if a third-party reseller or agent is involved.
  • New: KingswaySoft License Manager program now offers a link in the UI to help renew license maintenance or subscription with one single click.
  • Fixed: "Failed to retrieve the list of Dynamic GP objects" error in the Dynamics GP Source and Destination components when the toolkit is installed on a non-default path.

Version 20.1 - June 25, 2020

This release comes with the following updates:

  • Enhancement: Dynamics GP Destination component now supports working with duplicate column names from upstream components as long as the columns are coming from different sources.
  • Update: We have adopted a new versioning strategy in this release. From this point on, all future releases will be versioned as YY.ReleaseWave.ServiceReleaseNumber.BuildNumber, where YY is the year in two digits. This helps simplify our communications with partners and clients in terms of a particular toolkit installation's maintenance status among many other benefits. This is implemented across the board for all of our SSIS toolkits including SSIS Productivity Pack. All our current releases should have the same version number of v20.1.0 with a revision number between 1561 and 1565.
  • Update: We have introduced a new branding panel in our UI forms to distinguish our components from those out-of-box ones.
  • Update: We updated .NET framework requirement to v4.6.1 for SSIS 2012 and above.
  • Update: Our license manager program now requires .NET Framework 4.0 or above.

Version 4.1 - October 3, 2019

This release comes with the following updates and enhancements:

  • Enhancement: Enhanced error handling.
  • 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.
  • Enhancement: Improved Azure SSIS-IR licensing to avoid unexpected unsuccessful activations upon restart.

Version 4.0 - February 21, 2019

This release comes with the following updates and enhancements:

  • New: We have added support for SSIS 2019.
  • Enhancement: Various UI enhancements and performance improvements.
  • Deprecation: We removed support for SQL Server 2005.

Version 3.1 - August 17, 2018

This release comes with the following updates and enhancements:

  • Enhancement: We have updated the license manager program to now report details of distinct connections in use.
  • Enhancement: Some minor UI adjustments.
  • Fixed: Our software may report a connection metering related error during runtime for some specific system environments.

Version 3.0 - April 26, 2018

This release comes with the following updates and enhancements:

  • 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: Dynamics GP Source component did not support regular expression.

Version 2.2 - December 14, 2017

This release comes with the following updates and enhancements:

  • New: We added support for Dynamics GP 2018.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.
  • Fixed: You might receive a datetime conversion error at runtime when the source query in GP Source component contains an SSIS datetime variable.

Version 2.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.
  • Update: Some updates to the licensing component.

Version 2.0 - July 7, 2017

This release comes with the following updates and enhancements:

  • New: We added support for SQL Server 2017.
  • Enhancement: Improved high-DPI support.
  • Enhancement: Some minor GUI improvements.
  • Enhancement: We added command line support for License Manager program
  • Fixed: If you have an Ultimate trial license, it may still report as not licensed.

Version 1.5 - September 15, 2016

This release comes with the following updates and enhancements:

  • New: We added support for writing to "AA Transaction Dimension Code Maintenance" object in Dynamics GP destination component.
  • New: We added support for writing to "Receivables Cash Receipt" object in Dynamics GP destination component.

Version 1.4 - August 10, 2016

This release comes with the following updates and enhancements:

  • New: We added support of generating GP next Payment Number and Alignment Number for Payable Management.
  • New: We added support for Dynamics GP 2016.

Version 1.3 - May 2, 2016

This release comes with the following updates and enhancements:

  • New: We added support of automatic cleanup eConnectOutTemp table when the "Violation of PRIMARY KEY constraint 'PK_eConnect_Out_temp'. Cannot insert duplicate key in object 'dbo.eConnectOutTemp'. " error is encountered. This helps eliminates the situation that GP procedures get stuck due to the residual records in the table, which requires manual intervention.
  • New: We added column/field filtering capabilities in GP source component editor window.
  • Enhancement: Updated support for the latest SQL Server 2016 release candidate builds.
  • Enhancement: Running the 32-bit installation package on a 64-bit operating system is now blocked, as doing so makes our connection manager unrecognizable in 64-bit runtime.
  • Enhancement: We removed the requirement of .NET Framework 3.5 SP1 for SSIS 2012 and later.
  • Enhancement: Some performance improvement in GP destination component.
  • Fixed: The descriptive error reporting may not work sometimes even the error catalog has been provided correctly.
  • Fixed: We fixed the automatic truncation of decimal numbers in the GP source component.
  • Fixed: You may encounter an XML error when using SQLQuery in GP source component.

Version 1.2 - January 22, 2016

This release contains the following updates:

  • New: We added support for SQL Server 2016 (Visual Studio 2015 SSDT for design time).
  • New: GP Next Document Number Component now supports RMA object.
  • Fixed: You may receiving following error - 'The parameter data type of SByte is invalid' (Thanks to Jutta for reporting this).

Version 1.1 - June 9, 2015

This release contains one minor update:

  • Update: GP Destination Component now performs a complete SSIS metadata update when a field is deleted based on schema file when the Refresh Component button is clicked (The previous could leave orphan SSIS metadata in the package when this happens).

Version 1.0 SR-1 - February 26, 2015

This release contains one minor update:

  • Update: GP connection manager can now handle special characters in its connection string.

Version 1.0 - December 12, 2014

This is our first public official release of SSIS Integration Toolkit for Microsoft Dynamics GP software.

  • Four main components
    • GP Connection Manager
    • GP Source Component
    • GP Next Document Number Generator Component
    • GP Destination Component
  • Support for SSIS 2014, 2012, 2008R2, 2008, or 2005
  • Support for the following four actions in GP destination component
    • Create
    • Update
    • Delete
    • Void

Sign up to receive notifications on software updates and enhancements.