Version 6.1 - October 6, 2017

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

  • 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: We added support for multi-threaded writing in the SharePoint destination component, you can now use one single option to configure the number of simultaneous threads used to write to SharePoint in parallel.
  • New: We added support for the Home Realm Uri option for Online Federation connections, this can help work with the connect that involves ADFS or some special identity provider federated with your SharePoint online services. The Home Realm Uri option was previously only available to on-premise federation connections.
  • Enhancement: Some significant code refactoring for better performance and error handling.
  • Enhancement: Text lookup feature for user/group lookup fields now supports all applicable fields instead of just the Name field.
  • Fixed: Text lookup feature did not work for user/group lookup fields. This was a regression bug introduced in our previous release.
  • Update: Some updates to the licensing component.

Version 6.0 - July 7, 2017

This release comes with the following updates and enhancements:

  • New: We added support for SQL Server 2017.
  • New: We added a Moderate action to SharePoint destination component, which can be used to perform content approval.
  • New: We added an Expression Editor button to both the SharePoint source and destination components.
  • Enhancement: Improved high-DPI support.
  • Enhancement: Some minor GUI improvements.
  • Enhancement: We added command line support for License Manager program.
  • Update: We no longer deploy Newtonsoft.Json.dll assembly to Windows GAC.
  • Fixed: If you have an Ultimate trial license, it may still report as not licensed.

Version 5.1 - March 15, 2017

This release comes with the following update:

  • New: Audit fields can be enabled for writing in SharePoint destination component using Add Audit Fields button in its editor window.
  • Update: SharePoint source component now handles the situation when invalid XML characters are returned from SharePoint server if any such characters were previously saved in SharePoint.
  • Update: The AdditionalQueryOptions property in SharePoint source component now can be parameterized using SSIS expressions. 
  • Fixed: Text lookup settings for User/Group lookup fields may be lost when Refresh Component is clicked in the destination component.
  • Fixed: For some unique SharePoint lists, the Premium File Transfer Task may fail to read or write files.

Version 5.0 - January 27, 2017

This release comes with the following update:

  • New:  We added a new option to the SharePoint source component which supports adding Additional Query Options (in XML) when reading data from SharePoint.
  • New: We added a new option to the SharePoint source component - Retrieve First Page Only, which can be used to limit the number of records returned when reading from SharePoint.
  • New: We added a CheckIn action to SharePoint destination component, which allows to check in files.
  • New: We added a CheckOut action to SharePoint destination component, which allows to check out files.
  • New: We added a ProxyMode option to SharePoint connection manager, which now supports three types of proxy mode: No Proxy, Auto-detect and Manual.
  • Enhancement: Improved error handling in SharePoint destination component when 'Redirect rows to error output' error handling option is used.
  • 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. 
  • Fixed: SharePoint destination component might not process the input data correctly when you use Text Lookup feature for a lookup field and the target list is large.

Version 4.4 - September 15, 2016

This release comes with the following update:

  • Enhancement: We now support working with hierarchical taxonomy values in the SharePoint destination component.
  • Enhancement: Writing to taxonomy fields is now allowed with Create action for document libraries.

Version 4.3 SR-1 - September 2, 2016

This release comes with the following update:

  • New: We added a new option to the SharePoint connection manager - HomeRealmUri, which provides support for the deployment that uses multiple identity providers.

Version 4.2 - August 10, 2016

This release comes with the following updates and enhancements:

  • New: We added a new option to the SharePoint connection manager - IgnoreCertificateErrors, which can be used to ignore any SSL certificate errors.
  • Fix: SharePoint destination component ignores the specified ContentType when trying to create a new record in a SharePoint destination component.
  • Fix: The Federation option in the connection manager did not work for some ADFS-based deployments.
  • Update: We upgraded the JSON library (Newtonsoft.Json.dll) to the latest version (v9.0.1).

Version 4.1 - May 5, 2016

This release comes with the following updates and enhancements:

  • New: We added a Query Designer in the SharePoint source component that can be used to design CAML query.
  • New: We added a new option to the SharePoint source component called "Remove ID Prefixes" which can be used to remove ID prefix from the values returned by SharePoint.
  • New: We added column/field filtering capabilities in SharePoint 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.
  • Enhancement: Better support of taxonomy field when working with SharePoint destination component.
  • Enhancement: We raised the default connection limit to 100 per host, this eliminates the need of using .config file to overwrite the default .NET framework limit of 2 connections per host.
  • Fixed: SharePoint destination component might throw an exception when trying to provide the newly created SharePoint document record ID (Thanks to Animesh and Andrew for reporting this issue).
  • Fixed: SharePoint destination component does not return any values for SharePoint_ID column when using CreateFolder action (Thanks to Rob for reporting this issue).
  • Fixed: In some unique situations, you might receive an error "There was an error when retrieving SharePoint lists. System.ArgumentException: ConcurrentDictionary_SourceContainsDuplicateKeys" when clicking the "Source List" or "Destination List" option in SharePoint source or destination component (Thanks to Arturo for reporting this issue).
  • Fixed: SharePoint source component has trouble working with a list that contains special characters in the list name (Thanks to Adam for reporting this issue).

Version 4.0 - January 22, 2016

This release comes with the following updates and enhancements: This release comes with the following updates and enhancements:
  • New: We added support for SQL Server 2016 (Visual Studio 2015 SSDT for design time).
  • New: We added support for Premium File Pack, that includes a total of 3 additional components and tasks, including Premium Flat File Source, Premium Flat File Destination component and Premium File Transfer Task. 
  • New: We added support for writing to Taxonomy fields (Thanks to Colin for this inquiry).
  • New: We added support for lookups for List items from a different site (Thanks Thomas for reporting this).
  • New: We added a new option in SharePoint connection manager in order to support multi-authentication site (Thanks to Nirav for reporting this issue and the recommendation for the solution).
  • Fixed: Downloading from Form Library may end up with a file of HTML content which is not the actual file content in the library. (Thanks to Peter for reporting this issue).
  • Fixed: In some cases, you may get (400) Bad Request error.
  • Fixed: Reading from SharePoint some numeric fields in SharePoint source component only returns a value of either 0 or 1 (Any existing component needs to be updated using the Refresh Component button in order for the fix to work) (Thanks to Nirav for reporting this issue).
  • Fixed: SharePoint connection did not work properly for some special Office 365 instances.
  • Fixed: If SharePoint source component has a Source View selected, when it is re-opened, the Refresh Component will ignore the source view selected.
  • Fixed: When a lookup field is pointing to a list in a different site (such as a subsite or the parent site), the destination component fails to populate SSIS column metadata.
  • Fixed: SharePoint destination component did not write any NULL value fields for Update action.
  • Fixed: When attachment extraction settings are configured for a form library in SharePoint source component, it will report an error complaining "Column 'Attachments' does not exist. It may have been deleted by another user." (Thanks to Peter for reporting this issue).

Version 3.0 - September 15, 2015

This release comes with the following updates and enhancements:
  • New: We added support of folder structure for SharePoint lists.
  • New: CreateFolder action now works for SharePoint list as well.
  • New: We added a new virtual field call Virtual_LocalRelativePath to both SharePoint source and destination components, which can significantly simplify data migration or synchronization between SharePoint lists or document libraries.
  • New: When Update or Delete action is used in SharePoint destination component, the ID field now supports using Text Lookup feature.
  • Update: SharePoint source component and destination component now save SourceList and DestinationList properties in plain text format of the list name, instead of a complex serialized XML in previous versions, as the XML format includes the list's ID in GUID format, which can cause some difficulties when promoting SSIS packages across environments.
  • Enhancement: Better support for SharePoint online authentication.
  • 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 significant re-engineering for better performance and robustness.

Version 2.0 - June 9, 2015

This release comes with the following updates and enhancements:
  • Breaking Change: We renamed our SharePoint connection manager from "SharePointConn" to "SharePoint (KingswaySoft)" (for those clients who have developed SSIS packages, you need to edit the package files in XML code mode and make the replacement accordingly).
  • Breaking Change: We renamed those attachment fields for both SharePoint source and destination components so they use Attachment_NN_BinaryContent as the DT_IMAGE field, and Attachment_NN_FileName as the string field that stores the file attachment's name.
  • New: We added supported of Text Lookup feature in SharePoint destination component.
  • New: We added a new feature in the Source Component called Document Scope which allows you to specify the recursion behavior when reading from SharePoint Document Libraries.
  • 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: SharePoint 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: We added a CreateFolder action to SharePoint destination component, which allows to create folder structure without actually writing any records or documents.
  • New: We added support of using SSIS variables in SharePoint source component's CAML query filter option.
  • Update: SharePoint connection manager can now handle special characters in its connection string.
  • Enhancement: Improved error handling.

Version 1.0 - December 12, 2014

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

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