What's New

SSIS Productivity Pack

Detailed changelog for every release of KingswaySoft SSIS Productivity Pack

Version 24.1 - June 12, 2024

This release comes with the following updates and enhancements:

  • General
    • New: We have added a discretional component refresh feature to various source components so that you can choose different metadata refresh strategies. In doing so, you may be able to retain some of the custom metadata changes that you have made to the source components.
    • Update: We have introduced a newly designed exception message window for better usability.
    • Enhancement: Some additional DPI display optimizations in various windows.
    New Components
    • HTTP/Web Services
      • Monday.com Connection Manager
      • Monday.com Source
      • Monday.com Destination
    • NoSQL Components
      • Firestore Connection Manager
      • Firestore Source
      • Firestore Destination
      • HBase Connection Manager
      • HBase Source
      • HBase Destination
    • Premium Data Flow Components
      • SQL Server Connection Manager
      • Premium SQL Server Source
      • Premium SQL Server Destination
      • Premium SQL Server Command Task
    • New services in the REST framework
      • Crelate
      • GetResponse
      • Google Cloud Monitoring
      • Google Dataplex
      • OpenAI
      • Qualtrics
      • Replicon
      • Wrike
  • Big Data
    • New: We updated the Parquet library to the latest version used by the Premium Data File components.
    • Fixed: When working with Parquet files, the Premium Data File source component may not return proper values for those fields that have a name which ends with a space.
  • Cloud Storage
    • New: Azure Files connection manager now supports a new SAS URL authentication mode.
    • New: We added support for "Anonymous Read Access for Public Containers and Blobs" authentication mode in Azure Blob Storage Connection Manager.
    • New: We added Dropbox business account support.
    • New: We added multi-threaded download support in S3 Connection Manager.
    • Update: Azure Blob Storage components no longer validate SAS token format.
    • Fixed: Pagination may not work properly in the Azure Blob source component.
    • Fixed: Box source component may not read some field values correctly when using a batch size value less than 100.
    • Fixed: You may get the error "Cannot access child value on Newtonsoft.Json.Linq.JValue." when working with a restricted folder in the Box source component.
  • Data Quality and Comparison
    • Fixed: You may run into "The query string is missing a street" error when testing the connection in Address Verification Connection Manager.
  • Data Warehousing
    • New: We added Snowpipe bulk mode support to Snowflake destination component when performing Insert action.
    • New: We added IncludeErrorDetail property support to PostgreSQL, Redshift and Google AlloyDB Connection Managers.
    • Fixed: You may get the error "Required property ACCOUNT is not provided" in Snowflake Connection Manager when the password contains a semicolon.
  • Encryption and Compression Tasks
    • New: We added additional (*.pgp) extension to PGP file chooser dialogs.
  • Google Services
    • General New: We added support for working with a JSON key file stored in Azure Blob Storage by specifying an Azure SAS URL as the JSON Key File Path in Google Connection Managers.
    • New: Google BigQuery destination component now supports using Avro and Parquet file formats for bulk data upload.
    • New: Google Ads Connection Manager now lists API version details when selecting. 
    • Enhancement: We have improved data uploading performance to Google BigQuery by utilizing compression streaming (Gzip).
    • Enhancement: Google Ads source component now retains the data type changes.
    • Fixed: Google BigQuery source component or Command Task may not work properly when SSIS variables are used in the source query.
    • Fixed: Google BigQuery Command Task may report the error "Provided command did not return any rows" when Output Type is set to "Single Row".
    • Fixed: Millisecond part in datetime value was dropped when writing datetime values in Google BigQuery destination component using Bulk Upload.
  • HTTP/Web Services
    • New: HTTP Requester Task and HTTP Requester Component now support sending multipart requests in batches. 
    • New: HTTP Requester Task and HTTP Requester component now supports sending GET requests with a request body.
    • New: GraphQL source component now supports using SSIS variables in the Arguments grid.
    • New: We added support to work with deprecated queries and mutations in GraphQL source and destination components.
    • Enhancement: Better socket management when sending requests in HTTP Requester Task and HTTP Requester component.
    • Enhancement: Better complex object type field support in GraphQL source component when the complex object lacks definition in the schema.
    • Update: We increased the maximum value of Field Expansion Depth in Web Service components.
    • Fixed: GraphQL source component didn't output array values in the correct format.
  • JSON & XML Processing
    • New: We added the default "Accept: application/json" header to JSON source component.
    • New: We added the default "Accept: application/xml" header to XML source component.
    • New: We added the default "Content-Type: application/json" header to JSON destination component.
    • New: We added the default "Content-Type: application/xml" header to XML destination component.
    • Fixed: JSON source component may report the error "Unable to cast object of type 'System.Numerics.BigInteger' to type 'System.IConvertible'" when working with large numeric values.
    • Fixed: You may receive a "Token StartObject in state Object would result in an invalid JSON object" error in the JSON destination component when the Empty Object Mode is set to "Null Value".
    • Fixed: Changing column name through Output Settings in JSON/XML source component Document Designer did not get saved properly.
  • Marketing Intelligence
    • Update: We have updated the OAuth scope when generating the OAuth token in Bing Ads Connection Manager according to the documentation.
  • Mail Components
    • New: We added support for returning ReceivedDate in the Email source component when working with Exchange Web Service and IMAP protocols.
    • New: Email Connection Manager now supports NTLM authentication type.
    • Fixed: You may get a NullReferenceException in the error message when the Error Output is enabled in Email destination component.
  • NoSQL Components
    • New: We added "mongodb srv" schema support in MongoDB Connection Manager.
    • Fixed: Couchbase source component may report the error "The operation is not allowed on non-connected sockets" when working with a cloud-based instance.
    • Fixed: MongoDB Connection Manager may report "There is already a serializer registered for type Guid" error when testing the connection multiple times.
    • Fixed: You may get "Connection Failed" error in Redis connection manager when working with a Redis instance that requires username credentials.
  • Premium Data Flow Components
    • New: We added "Skip Empty Rows" support in Premium Excel source component.
    • New: We added Error Output support in the Premium Excel source component.
    • New: Premium Service Lookup component now supports returning multiple matching records (including all). This should be considered a breaking change, the component now works as an asynchronous component when the Max Returned Matches option is set to be greater than 1. Any existing references to the_HasMoreThanOneMatch output column in downstream pipeline components should be updated to use the new _HasMoreThanMaxReturnedMatches column instead.
    • Update: Premium Service Lookup component now uses Full Cache as the default caching option after the component is created.
    • Fixed: "Format String" option in the Premium Excel destination component may not apply to the column properly when the target column is in DT_CY data type.
    • Fixed: You may get error "An item with the same key has already been added" when there are duplicate column names specified in the Premium Excel Destination component.
    • Fixed: You may run into "Method not found" error when performing bulk writing against MySQL database in the Premium ADO NET destination component.
    • Fixed: Premium Lookup component may report validation error "The component has detected potential metadata corruption during validation" when the component is copied.
  • Premium File Pack
    • New: Premium Transfer Task now reports source path and target path values in error message.
    • New: We added support for using two concatenated characters as text delimiter in the Premium Flat File source component.
    • New: SFTP Connection Manager now supports setting Mac Algorithms.
    • Update: Premium Flat File source component now outputs empty string to the first column when working with empty rows while the "Skip Empty Rows" option is disabled. This should be considered a breaking change.
    • Fixed: You may receive NullReferenceException when writing a NULL value to a local file property.
  • Security Management Components
    • Fixed: You may get a NullReferenceException when opening an Azure Key Vault Connection Manager if the connection manager is configured with Certificate authentication mode.
  • REST Components
    • New: REST source component now provides a discretionary update experience in which you can choose how refresh should be performed in case any column-level property changes made manually should be retained.
    • Acumatica
      • Fixed: Duplicate fields in REST Acumatica source and destination components.
    • BigCommerce
      • Update: We have performed a major metadata refresh and update.
      • Update: We removed the Client ID property from REST BigCommerce Connection Manager because the X-Auth-Client header is deprecated.
    • Chargify
      • Update: Chargify service has been renamed to Chargify/Maxio to reflect the vendor's recent branding changes.
    • Facebook Business
      • Update: "Use Page Token" property is now available to all endpoints in REST Facebook Business source component.
      • Update: We updated the default API Version to v19.0.
      • Fixed: REST Facebook Business destination component may not pass the page_id value properly when working with a page-related action endpoint.
    • Facebook Messenger
      • Update: We updated the default API Version to v19.0.
    • Freshs ervice
      • Update: Updated metadata in Asset object.
    • Google Calendar
      • Update: Updated metadata in in event.watch and event.list objects.
    • Magento/Adobe Commerce
      • Fixed: REST Magento/Adobe Commerce destination component may not detect custom fields properly.
    • Microsoft Planner
      • New: We added OAuth Client Credentials and Certificate authentication mode support in REST Microsoft Planner Connection Manager.
    • Microsoft To Do
      • New: We added OAuth Client Credentials and Certificate authentication mode support in REST Power BI Connection Manager.
    • Microsoft Teams
      • New: We added OAuth Certificate authentication mode support in REST Microsoft Teams Connection Manager.
    • Power BI
      • New: We added OAuth Client Credentials and Certificate authentication mode support in REST Power BI Connection Manager.
    • Salesforce Pardot
      • Update: Updated metadata in Email object.
    • Shopify
      • Update: Updated metadata to remove deprecated fields.
    • Zoho Books
      • Update: We have updated the base URL according to the API update.
    • Zoho CRM
      • Update: Updated metadata in the Attachments object.
    • Zoom
      • New: We added Zoom Events API support.

For previous releases click on the respective year:
2023 - 2022 - 2021 - 2020 - 2019 - 2018 - 2017 - 2016

Sign up to receive notifications on software updates and enhancements.