Version 20.1.0.1761 - 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