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