SSIS Integration Toolkit for Team Foundation Server

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.
  

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):

• Enhancement: The Team Foundation Source component no longer fails when there is an error reading work item attachments. Instead, it should report an SSIS warning but the process can continue.
• Update: We have updated those Microsoft client libraries to the latest version.
• 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.

Version 21.2 - November 11, 2021

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

• New: We added a new action button in the KingswaySoft License Manager which makes it easy to request a free trial.
• New: We added limited password attempts feature to Connection Managers that use OAuth token file. When the limit is reached, access_token and refresh_token values will be deleted from the token file, this is to protect the file from unauthorized use.

Version 21.1 - May 28, 2021

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

• New: We now ship a 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.
• Fixed: Team Foundation Source component may output "Microsoft.VisualStudio.Services.WebApi.IdentityRef" value when reading AssignedTo through a REST connection.
• Fixed: Tam Foundation Destination component may not create WorkItemAssociation properly when working with a REST connection.
• Fixed: "System.ArgumentException" error when clicking the expression "fx" button in Team Foundation Source/Destination component in SSIS 2014+ versions.

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.
• Update: We have renamed the OnlineTeamServices authentication type to AzureDevOpsPersonalAccessToken in the Team Foundation connection manager to better align with Microsoft terminology.

Version 20.1.0 - June 5, 2020

This release comes with the following updates:

• New: We added support for REST API.
• Enhancement: Team Foundation Destination component now supports working with duplicate column names from upstream components as long as the columns are coming from different sources.
• Enhancement: We have made some minor improvements in our retry implementation on intermittent errors.
• 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 3.1 - October 3, 2019

This release comes with the following updates and enhancements:

• 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 3.0 - February 21, 2019

This release comes with the following updates and enhancements:

• New: We have added support for SSIS 2019.
• New: We added an IgnoreCertificateErrors option in Team Foundation connection manager, which can be used to ignore any server SSL certificate errors.
  
• Enhancement: Various UI enhancements and performance improvements.

Version 2.1 - August 16, 2018

This release comes with the following updates and enhancements:

• New: Team Foundation Source now supports retrieving linked work items.
• 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: Team Foundation components may cause Visual Studio 2017 to crash when connecting to Team Foundation Server through Team Explorer.

Version 2.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).

Version 1.0 - October 6, 2017

This is our first public final release of SSIS Integration Toolkit for Team Foundation Server software.

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