SSIS Integration Toolkit for Directory Services

Version 23.2 - September 7, 2023

This release comes with the following updates and enhancements:

• General
  • 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.
• Azure Active Directory
  • New: We added support for device object when working with an Azure Active Directory via the Active Directory source and Active Directory destination component. 
    
  • New: When using userPrincipalName as a search criteria for GroupMembers object in Active Directory source component, the component can fail with an error.
    
  • Enhancement: We have moved the Container Path option from component level to record level by having the option surfaced as a column in the Active Directory destination component. Existing Container Path configuration should still be respected.
• On-Premises Active Directory
  
  • Enhancement: We have made some optimizations to the Active Directory source component for better efficiency and maintainability.
  • Fixed: The AccountExpirationDate field does not return any values with an Active Directory source component.
    
• LDAP
  • New: We added SSL certificate support for LDAP connections.
  • Enhancement: We have moved the Container Path option from component level to record level by having the option surfaced as a column in the LDAP destination component. Existing Container Path configuration should still be respected.

Version 23.1 - March 17, 2023

The following are the updates and enhancements made for each group of components - Note that this will be our last version that supports SSIS 2008 (SQL Server 2008).

• General
  
  • 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.
    
• Active Directory
  • New: Generating OAuth token in Active Directory Connection Manager now supports modifying the OAuth scopes.

Version 22.1 - October 19, 2022

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

• General
  
  • 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.
• Active Directory
  • New: We added Case Insensitive Matching support when working with Manually Specified Keys in Active Directory Destination for Active Directory on-premises connection.
  • Update: Client Secret is now an optional property when generating Azure AD OAuth token in Active Directory Connection Manager.
  • Fixed: Active Directory Source component may not read complete User records from a group Container path when working with Active Directory on-premises instance.
  • Fixed: Active Directory components remain silent when there is a connection error while adding custom fields for Azure Active Directory connection, instead of reporting the connection error.
    
• LDAP
  • Fixed: Test Connection in LDAP Connection Manager may not report error properly.
  • Fixed: You may get incomplete person records from a group Container path when working with person object in LDAP Source component.
    

Version 21.2 - November 11, 2021

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

• General
  
  • 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.
• Active Directory
  • New: We added a proper writing support for pwdLastSet field in the Active Directory Destination component, which would previously error out with a "System.DirectoryServices.AccountManagement.PrincipalOperationException: Unspecified error".
  • Fixed: Directory Service component was reporting an error when it fails to load the container path.

Version 21.1 - May 28, 2021

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

• General
  • 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.
  • New: Our HTTP based connections now support TLS 1.3.
• Google Directory
  • New:   We added the following new components:
    
    • Google Directory Connection Manager
    • Google Directory Source
    • Google Directory Destination
• LDAP
  • New:  We added the following new components:
    
    • LDAP Connection Manager
    • LDAP Source
    • LADP Destination
• Active Directory
  • New:  Active Directory Source/Destination component now supports working with Azure extension properties in User/Group object.
  • New: Active Directory Source component now supports reading photo data for Azure User/Group objects.
  • New: We added a new Update Photo action in Active Directory Destination component for Azure Active Directory connection.
  • New: Active Directory Destination component now support assigning a user's manager when working with User object for Azure Active Directory connection.
  • Enhancement: Updated User and Group objects metadata for Azure Active Directory.
  • Update: Active Directory Connection Manager no longer requires providing client_secret to generate OAuth token for Azure Active Directory connection
  • Fixed: Active Directory Source component may not read accountExpires/AccountExpirationDate/LastLogon values properly when working with an on-premises environment.
  • Fixed: You may get an "Object reference not set to an instance of an object" error in Active Directory Destination when the package was upgraded from v6.1 to v20.2.
    

Version 20.2 - November 4, 2020

This release comes with the following updates and enhancements:

• 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: User object has some new metadata when working with an Azure Active Directory connection in either the Active Directory source or destination component.
  
• Enhancement: Updated metadata for User and Group object for Azure Active Directory connection.
• Fixed: "There was no Objects found" error in Directory Service Destination component when using objectSid/objectGUID as matching key to perform Update or Upsert action while working with an on-premises Active Directory connection.
  
• Fixed: Directory Service Destination component fails to update BusinessPhones when the option "Ignore Unchanged Fields" is enabled while working with Azure Active Directory.
• Fixed: 400 Bad Request "Invalid filter clause" error which occurs in the following situation: the input key field value contains single quotes in an Azure Active Directory connection and the Update, Upsert, or Delete actions are used with manually specified key(s) in the Directory Service Destination component.
  
• Fixed: Directory Service Source component did not retrieve all users from the on-premises Active Directory instance, in certain situations.
  

Version 20.1 - June 5, 2020

This release comes with the following updates and enhancements:

• New: We added Manually matching criteria support when performing Update/Upsert/Delete action in Active Directory Destination component.
• New: We have added a new Ignore Unchanged Fields option to the Active Directory Destination component.
• New: Active Directory Source/Destination component now supports working with Azure custom properties in User/Group object.
• New: Active Directory Source component now supports reading Group Members when working with an Azure Active Directory connection.
• New: We added support for working with Contact in Active Directory Destination component with an on-premises Active Directory connection.
• New: We added support of specifying Tenant Id in the OAuth 2.0 authorization code flow when working with an Azure Active Directory connection in Active Directory Connection Manager.
• Enhancement: Active Directory 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 when working with an Azure Active Directory connection.
• 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 have switched to using token files instead of relying on Windows registry for better security and easier deployment when working with an Azure Active Directory connection.
• 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 receive empty values (NULL) in the "member" field when reading from Group in Active Directory Source component if it is an on-premises Active Directory connection.
• Fixed: Active Directory Destination component may only send input datetime values in local system's timezone when working with an Azure Active Directory connection.
• Fixed: Active Directory Destination component may ignore input NULL values when performing Update action when working with an Azure Active Directory connection.

Version 6.1 - October 3, 2019

This release comes with the following updates and enhancements:

• New: We added a new field called MemberContainer to GroupMembership object in Active Directory Destination component when working with On-Premises connection, which can be used to add a member from a different container path to a group.
  
• New: We added a new field called MemberType to GroupMembership object in Active Directory Destination component when working with On-Premises connection, which can be used to add a group as a member to a group.
• 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 6.0 - February 21, 2019

This release comes with the following updates and enhancements:

• New: We have added support for SSIS 2019.
• New: We added support for Client Secret for Azure AD connection managers.
• New: We now support reading the full list of members for the "member" field in Active Directory source component.
• New: We added support for reading various single-user properties in Active Directory source component when it is an Azure AD connection.
• New: We now support writing to 'manager' field in Active Directory destination component when it is an Azure AD connection.
• Enhancement: Various UI enhancements and performance improvements.
• Deprecation: The AccountId property is no longer needed for Azure Active Directory, therefore it is removed from the Active Directory connection manager. Your package should not be affected, but the new version will not save the property anymore going forward.
• Deprecation: We removed support for SQL Server 2005.

Version 5.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.
• Fixed: Our software may report a connection metering related error during runtime for some specific system environments.
• Fixed: Active Directory Source component may report "The given key was not present in the dictionary" error when reading from an on-premises environment with Lastname column enabled.

Version 5.0 - April 26, 2018

This release comes with the following updates and enhancements:

• New: We added support for Organization Unit object in the Active Directory Source component with On-Premises connection.
• New: We added support for writing to Organization Unit in the Active Directory Destination component with On-Premises connection.
• 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).
• Enhancement: We added command line support for Azure AD Token Manager program.

Version 4.0 - December 14, 2017

This release comes with the following updates and enhancements:

• New: We added support for Azure Active Directory.
• New: We now support reading the GroupScope, Guid, IsSecurityGroup fields in the Active Directory Source component when Group is the source object.
• Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 3.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 3.0 - July 7, 2017

This release comes with the following updates and enhancements:

• New: We added support for SQL Server 2017.
  
• Update: We changed UserAccountControl field's data type to int instead of nvarchar(4000) previously.
• Fixed: When working with datetime field, in some occassions, you might run into an error indicating "System.ArgumentException: Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks".
• Fixed: When one of UserAccountControl related fields is selected, but not the UserAccessControl field, the Active Directory source component will empty value (NULL) for those related fields.
• Enhancement: Improved high-DPI support.
• Enhancement: Some minor GUI improvements.
• Enhancement: We added command line support for License Manager program.

Version 2.4 - October 24, 2016

This release comes with the following updates and enhancements:

• Enhancement: We added two new fields to the Move action in Active Directory destination component, which allows the renaming of UserPrincipalName and SAMAccountName.
  
• Enhancement: We added support of a few fields when working with Active Directory user object, including the support of reading and writing of thumbnailPhoto, employeeNumber, objectsid (read-only), etc.
• Enhancement: Active Directory destination component now supporting writing NULL values.
• Update: The license manager now supports co-termed subscription license.
• Update: We have lowered the minimum requirement of SQL Server editions when using our software.
  

Version 2.3 - September 15, 2016

This release comes with the following updates and enhancements:

• New: We added a new action in Active Directory destination component called Move, which can be used to move a specified AD object to another container path, also provided is the capability to rename an object using the same action.

Version 2.2 - May 5, 2016

This release comes with the following updates and enhancements:

• 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.
• Fixed: Active Directory source component does not return any values for those useraccesscontrol fields (such as Enabled) unless the useraccesscontrol itself has been selected.

Version 2.1 - January 22, 2016

This release comes with the following updates and enhancements:

• New: We added support for SQL Server 2016 (Visual Studio 2015 SSDT for design time).
  
• Fixed: You may run into the following error when working with User object: 'Container Path must not contain Common Names'.

Version 2.0 - September 15, 2015

This release comes with the following updates and enhancements:

• New: Support for upsert action in Active Directory Destination Component
• New: Custom fields can be added to Active Directory source and destination component using Add button in their editor windows.
• New: We added field filtering capabilities in Active Directory source component's Editor window.
• New: We added a new option in Active Directory connection manager called Context Binding which allows you to specify the context binding options when authenticating with Window Active Directory.
• Fixed: Active Directory source component is not able to show up, and it reports an error indicating that it could not load file or assembly 'FastColoredTextBox'.
• Fixed: Active Directory destination component fails to save NULL values for some Active Directory attributes by reporting an error saying "Value cannot be null".
• Enhancement: The license manager program now works in the system that has FIPS compliance policy enabled.
• Enhancement: Some minor UI adjustments including positioning UI windows in the center of parent screens upon initialization.
• Enhancement: Some performance improvements

Version 1.2 - June 9, 2015

This release comes with the following updates and enhancements:

• New: We added support for SSIS Integration Toolkit - Ultimate Edition, you can now license all our SSIS Integration Toolkit products using one single license key.
  
• Fixed: Active Directory connection manager used to save connection information when Test Connection button is clicked regardless of whether the changes are accepted by clicking the “OK” button.

Version 1.1 - February 26, 2015

This release comes with the following updates and enhancements:

• New: The output columns can now be selected and de-selected in Active Directory source component's editor window.
• New: We added field filtering capabilities in Active Directory destination component, which include Hide Mapped Fields, Hide Unmapped Fields buttons, and a textbox that accepts a search string.
  
• Update: Active Directory connection manager can now handle special characters in its connection string.
• Enhancement: Some performance tuning with Active Directory source component.

Version 1.0 - December 12, 2014

This is our first public release of SSIS Integration Toolkit for Directory Services software.

• Three main components
  
  • Active Directory Connection Manager
  • Active Directory Source Component
  • Active Directory Destination Component
• Support for SSIS 2014, 2012, 2008R2, 2008, or 2005
• Support for the following three actions in Active Directory destination component
  • Create
  • Update
  • Delete