Version 23.2.1 - Oct 12, 2023

This is a service release, which mainly contains the following bug fix:

  • Fixed: SharePoint source component might return empty values (NULL) for taxonomy field when the REST service endpoint is used.

Version 23.2 - September 7, 2023

This release comes with the following updates and enhancements:

  • New: We added <System>.ListMetadata object support in SharePoint source component, which can be used to retrieve the list of all lists and document libraries under a particular SharePoint URL or site with all their metadata returned.
  • 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.
  • Fixed: When using the Authorization Code authentication option, SharePoint connection manager may fail to connect with the token file after about 90 days due to expired refresh token.
  • Fixed: When the SharePoint connection is using the REST service endpoint, the SharePoint destination component might ignore the input values provided to the ContentType fields when writing to a document library item.
  • Fixed: Content Type property was not available in Premium File Properties task.

Version 23.1.1 - May 19, 2023

This release is mainly a service release, which comes with the following updates and fixes - Note that this will be our last version that supports SSIS 2008 (SQL Server 2008):

  • Enhancement: When working with the REST service endpoint, we now support chunked upload, which is enabled automatically when the file is above a particular size, this makes the upload more efficient and more reliable.
  • Fixed: When working with the REST service endpoint, pagination might not work properly when using view in SharePoint source component.
  • Fixed: When using a REST connection, the SharePoint destination component may not write to taxonomy fields properly.

Version 23.1 - March 17, 2023

This release comes with the following updates:

  • New: We added "Client Credentials using Custom App" OAuth Type support to SharePoint Connection Manager when working with REST service endpoint.
  • New: We added an "Avoid Solo Batch Requests" option to SharePoint Connection Manager.
  • New: We added <System>.Site object support in SharePoint source component, which can be used to retrieve the list of sites available under a particular SharePoint URL or site.
  • New: SharePoint REST connection now supports server-side move which can help achieve much greater performance if the files are moved using the same connection manager or SharePoint site.
  • New: SharePoint REST connection now supports server-side copy  which can help achieve much greater performance if the files are moved using the same connection manager or SharePoint site.
  • New: Premium Properties Task now supports renaming a SharePoint document library folder/file for both SharePoint REST and SOAP connections.
  • Enhancement: Some substantial enhancements when working with the Premium File Properties task that uses a SharePoint connection.
  • Update: SharePoint source components using a REST connection now outputs NULL for empty lookup values.
  • 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: The authorization server URL may not be sent correctly in SharePoint Connection Manager.
  • Fixed: You may get "exceeds the list view threshold" error in SharePoint source component when reading from a large document library through a REST connection.
  • Fixed: SharePoint source components using a REST connection may not output the records correctly when a view is specified.
  • Fixed: KingswaySoft License Manager might report an incorrect grace period when the license is running under the grace terms.

Version 22.1.1 - December 22, 2022

This is a service release which contains the following bug fixes since the v22.1 release: 

  • Fixed: SharePoint source component using a REST connection may not properly download some files if the file name contains some special characters.
  • Fixed: When uploading a file using the Premium File Transfer Task or Premium Flat File Destination component through a SharePoint REST connection, you may receive an Access Denied error when the file name contains some special characters.
  • Fixed: When the Folder Creation Mode is selected as "Create Based on Folder-Level Caches", the SharePoint destination component that uses a REST connection may fail to create subfolders underneath the one of the root folders.
  • Fixed: When the Download Version History option is used in the SharePoint source component that uses a SOAP connection manager, the component may fail to download document version histories by returning an error that says "The system cannot find the file specified", if the file name contains some special characters.
  • Fixed: When using a REST connection, the SharePoint source component may only return partial results of all available files in the document library due to those items deep in the folder structure being missed.
  • Fixed: When a view is selected in a SharePoint Source component that uses the REST connection, only the "Virtual_ParentFolderPath" field is shown in Columns page, but not any other fields.
  • Fixed: SharePoint destination component using a REST connection may not properly create certain folder with some special characters.
  • Fixed: SharePoint components may report (404) Not Found errors when working with the Documents library (the primary default library for any SharePoint site) if REST connection is used.
  • Fixed: SharePoint source components using a SOAP connection may not output user lookup field value correctly when the field is configured to show a non-default field.
  • Fixed: SharePoint source components using a REST connection may always output empty values (NULL) for some columns that start with the underscore (_) character.
  • Fixed: Premium File Pack components may not read or write properly to those custom fields that start with the underscore (_) character when REST connection is used.
  • Fixed: Premium File Pack components may not show up in SSIS toolbox.
  • Fixed: SharePoint connection manager may report an error that says "Token Path has not been provided" when a token path is not actually needed.
  • Fixed: SharePoint destination component that uses a REST connection may throw a Microsoft.SharePoint.Client.InvalidClientQueryException when writing to a hyperlink field. 

Version 22.1 - October 25, 2022

This release comes with the following updates:

  • New: We have added support for SQL Server 2022 (SSIS 2022).
  • New: We added support for the REST service endpoint in the SharePoint connection manager which provide some advanced integration features that were not possible using the SOAP service endpoint. 
  • New: SharePoint service is now supported in Premium File System source/destination and Premium Properties Task components.
  • 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.
  • Update: We have changed the Virtual_LocalRelativePath field name to Virtual_ParentFolderPath for better clarity. In doing so, a new SSIS metadata version (1) is introduced, this could be seen as a breaking change as an SSIS package saved in v22.1 cannot be opened by v21.2 or earlier.
  • Fixed: SharePoint Source component may report "Failed to convert "System.Byte[]" to DT_IMAGE" error when download large document library file.
  • Fixed: SharePoint Destination component may report "ArgumentOutOfRangeException: Number must be either non-negative and less than or equal to Int32.MaxValue or -1" intermittent error.
  • Fixed: You may run into error "Index was outside the bounds of the array" when uploading local files to SharePoint with filter conditions using Premium File Transfer Task.
  • Fixed: Downloading SharePoint files using Premium Transfer Task may not work properly when the provided SharePoint Source Path is a document library path.
  • Fixed: You may get "Invalid path" error when deleting SharePoint files in Premium File Transfer Task and the file name contains % or # character.
  • Fixed: SharePoint component may not make proper retry service calls on 429 response error.

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: We have added the Authorization Server URL support in the SharePoint Connection Manager, which can be used to specify an alternative authorization server URL when working with SharePoint 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.
  • New: SharePoint Destination component now supports renaming an existing file when performing Update action towards a document library item.
  • Enhancement: We have made some important enhancement to the authentication flow. In addition, modern authentication is tried before the legacy one for improved efficiency.
  • Enhancement: We updated the metadata for SharePoint currency fields so that it can contain some great numbers that might be stored in the system.
  • Update: SharePoint Source/Destination component now detects SharePoint currency field in SSIS DT_DECIMAL data type to avoid hitting "Value was either too large or too small for a Currency" error when working with large numbers. A refresh of the component using the "Refresh Component" button is required to get latest metadata.

Version 21.1 - May 28, 2021

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

  • New:We added a Folder Creation Mode property in SharePoint Destination component, which can be used to specify how to create folders when working with Document Library files.
  • New: We now ship a 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.
  • Fixed: SharePoint Destination component may not save the "Remove Invalid Characters" option setting properly.
  • Fixed: You may receive a "The file or folder name contains invalid characters" error when uploading a file name contains # or % characters in SharePoint Destination component.

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.
  • New: Some significant performance improvements in the SharePoint Destination component when uploading files to a large SharePoint document library with Virtual_LocalRelativePath specified.

Version 20.1 - June 15, 2020

This release comes with the following updates and enhancements:

  • New: We added support of working with enterprise keywords column in SharePoint Destination component.
  • New: SharePoint Destination component now supports returning document url values in the _DocURL column available in its default output.
  • Enhancement: Modern authentication support has been further improved when connecting to SharePoint online.
  • Enhancement: When working with SharePoint online, our SharePoint connection manager would now first attempt the modern authentication before falling back to the legacy authentication option.
  • Enhancement: SharePoint 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.
  • 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.
  • Update: We have updated our software signing by using a new certificate vendor, which might trigger a SmartScreen alert within the first couple of months from the release date. Rest assured we have done our best to make sure that your downloads from our website are trustworthy.
  • Fixed: SharePoint Source/Destination component might report a NullReferenceException when retrieving a List's metadata when the list contains special taxonomy fields.
  • Fixed: The Premium File task might report a NullReferenceException during runtime when it is configured to delete files from the root folder of a SharePoint Document Library.

Version 8.1 - October 3, 2019

This release comes with the following updates and enhancements:

  • New: We now support downloading the version history of files in Document Library in SharePoint Source component.
  • New: We added a new option called Authentication Cookie Name in SharePoint Connection Manager which can be used to set custom authentication cookie.
  • Enhancement: We have some further improvement in modern authentication support.
  • Enhancement: Improved handling of retry on HTTP 503 errors.
  • 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 8.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 Azure Active Directory authentication.
  • New: We now support connecting to the SharePoint environment that uses modern authentication.
  • New: We now support writing to Document Set and its properties.
  • Enhancement: Various UI enhancements and performance improvements.
  • Deprecation: We removed support for SQL Server 2005.

Version 7.1 - August 17, 2018

This release comes with the following updates and enhancements:

  • Enhancement: Improved performance when downloading files from SharePoint using Premium File Transfer Task component.
  • Enhancement: All SharePoint subsites including the root site are now counted as one connection when it comes to the distinct connection restriction.
  • 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: You may run into "Invalid text lookup settings" error with AssignedTo field even if it is not configured to use Text Lookup when the target is a Task-type list using the SharePoint Destination component.
  • Fixed: "Remove ID Prefixes" option in SharePoint Source component may work improperly with multi-lookup type fields.
  • Fixed: You may get "exceeds the list view threshold" error in SharePoint Destination component when performing CheckIn/CheckOut action towards a large document library.

Version 7.0 - April 26, 2018

This release comes with the following updates and enhancements:

  • New: We added Text Lookup support for UserMulti type and LookupMulti type fields in SharePoint Destination component.
  • New: Text Lookup now accepts null as Optional default value.
  • 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).
  • Fixed: Create Folder action may work improperly in SharePoint Destination component.
  • Fixed: You may get "exceeds the list view threshold" error when uploading files to a sub-folder of a large document library using SharePoint Destination component.

Version 6.3 - December 14, 2017

This release comes with the following updates and enhancements:

  • New: We added support for working with custom folder type in the SharePoint Destination component.
  • Fixed: You might receive Out of Memory errors (OutOfMemoryException) when uploading large files using the SharePoint Destination component.
  • Fixed: You may get "List does not exist" error when downloading files from Documents using Premium File Transfer Task.
  • Update: Update of licensing component to better support servers within a clustered environment to minimize potential false licensing errors.

Version 6.2 - October 30, 2017

This release comes with the following updates and enhancements:

  • Fixed: When working with Delete, CheckIn, CheckOut, and CreateFolder actions in SharePoint destination component, you might run into an error reporting as "System.ArgumentException: An item with the same key has already been added".
  • Fixed: You might run into issues when writing to a SharePoint list with a hierarchical structure.
  • Enhancement: We have made enhancement to the situation when writing to a list or document library which requires check-out, so that the process won't stop if the check-out operation fail before the actual Update takes place.

Version 6.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: 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-premises 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

Sign up to receive notifications on software updates and enhancements.