What's New

SSIS Integration Toolkit for Microsoft Project Server

Detailed changelog for every release of the Microsoft Project Server Integration Toolkit

Version 24.1 - June 12, 2024

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

  • New: We have added support for Assignments output column in Project Server Source Component when working with the Task object.
  • 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.

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.
  • New: Project Server Source component now supports outputting 3 fields, Value, FullValue and Description, when working with lookup field.
  • New: We have added the Authorization Server URL support in the Project Server Connection Manager, which can be used to specify an alternative authorization server URL when working with Project Server online, this is particularly useful when custom identity provider is used for online access. In addition, the feature provides a list of three new regional online authorization server support including GCC, German, and China.

Version 21.1 - May 28, 2021

This release comes with the following updates:

  • New: We added support for writing to custom lookup field in Project Server Destination component.
  • New: KingswaySoft License Manager program now always uses a secure service endpoint for activation and deactivation requests.
  • New: We now ship a new console version of KingswaySoft License Manager program which is designed to work more reliably in a container environment.

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.

Version 20.1 - June 5, 2020

This release comes with the following updates:

  • New: We added a new "Ignore Certificate Errors" option in Project Server Connection Manager, which can be used to ignore any SSL certificate errors.
  • Enhancement: Starting with this release, our software will automatically try the CSOM interface before attempting the legacy PSI interface when establishing the connection, if SSIS 2012 or above is used.
  • Enhancement: We have made some major enhancements on supporting modern authentication used in Project Server online.
  • Enhancement: Project Server 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.
  • Fixed: You may run into "Attempt to update timesheet failed. Assignments may be on projects in visibility mode or have been removed." error in Project Server Destination component when writing to TimesheetLineDetail with non-project work.

Version 4.1 - October 3, 2019

This release comes with the following updates and enhancements:

  • New: We now support connecting to the Project Server environment that uses modern authentication.
  • 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.
  • New: We added an IncludeInactiveUsers option in Project Server source component so it can report timesheet records associated with users that are no longer active in the system.
  • 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:

  • New: We introduced support for two additional error columns: ErrorCode2, ErrorMessage2 in the Project Server Destination component. This change involves new SSIS metadata, and it may be considered as a breaking change, as your components will be automatically upgraded once opened, which can no longer be opened in prior releases.
  • Enhancement: We improved the error handling when a record fails to write to Project Server.
  • 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: In some specific situations, you may get error "An item with the same key has already been added" when writing TimeSheetLineDetail entity with multiple input rows.

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

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.
  • New: Connections to project server are now made with the latest and greatest TLS protocol whenever possible.
  • Fixed: The source components might fail to read from a Project Server 2013 instance for certain entities. This is a regression bug which was introduced in our v2.0 release.
  • 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.
  • New: We added support for Project Server Online.
  • 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.1 - May 5, 2016

This release comes with the following updates and enhancements.

  • New: We added support of TimesheetLineDetail entity which can be used to read from or write to the actual rows in Project Server.
  • New: We added column/field filtering capabilities in the Project Server 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.

Version 1.0 - January 22, 2016

This is our first public release of SSIS Integration Toolkit for Microsoft Project Server software.

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

Sign up to receive notifications on software updates and enhancements.