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-premise 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-Premise connection.
  • New: We added support for writing to Organization Unit in the Active Directory Destination component with On-Premise 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
%MCEPASTEBIN%