What's New

SSIS Productivity Pack

Detailed changelog for every release of KingswaySoft SSIS Productivity Pack

Version 25.1 - April 4, 2025

This release comes with the following updates and enhancements:

  • General
    • Enhancement: We have some updates to the license update check module so that it should be more resilient and it will log a Windows event should there be a problem with the network connection.
    • Enhancement: We have made various additional DPI display optimizations.
    • Update: We have updated the third-party library dependencies shipped in our software, including the removal of DotNetZip library, and the update of Irony, Newtonsoft.json, NodaTime, CosmosDB, and Snowflake, among many other libraries.
  • New Components
    • Cloud Storage
      • OneLake Connection Manager
      • OneLake Source
      • OneLake Destination
    • Data Warehousing
      • Databricks
        • Databricks Connection Manager
        • Databricks Command Task
        • Databricks Source
        • Databricks Destination
      • PrestoDB
        • PrestoDB Connection Manager
        • PrestoDB Command Task
        • PrestoDB Source
        • PrestoDB Destination
    • New services in the REST framework
      • Azure Databricks Administration
      • Azure Maps
      • Google AppSheet
      • Google Cloud Trace
      • Zoho Bigin
  • Cloud Storage
    • New: We added the following new authentication mode options in Azure Files Connection Manager:
      • OAuth Authorization Code
      • OAuth Client Credentials
      • SAS Token
    • New: We added SAS URL authentication mode in Azure Data Lake Storage Connection Manager.
    • New: We added SAS URL authentication mode in Azure Blob Storage Connection Manager.
    • Fixed: You may get an unauthorized error when performing chunk download while working with OneDrive personal account.
    • Fixed: You may run into a "(400) Bad Request" error in Azure Data Lake Storage source component when reading from a container path.
    • Fixed: Pagination may not work properly in Azure Data Lake Storage source component.
    • Fixed: You may run into an AuthenticationFailed error when listing folder items while working with an Azure Files connection that uses the SAS URL authentication mode.
    • Fixed: You may get an "Invalid SAS Token" error in File Chooser when working with Azure Files with SAS URL authentication mode and the SAS URL only has List permission.
  • Data Quality and Comparison
    • Fixed: "Match Strategy" may not work properly in Address Verification component when working with a SmartyStreets connection.
  • Data Warehousing
    • New: Premium ADO NET Command Task, Premium ADO NET source and destination components now have support for output parameters, which makes it possible to receive output parameter values when necessary.
    • New: We added a new Upsert Mode option in Premium ADO NET destination component, which supports configurations such as Full Upsert, Insert Only (existing records ignored), and Update Only (new records ignored).
    • New: Premium SQL Command Task, Premium SQL source and destination components now have support for output parameters, which makes it possible to receive output parameter values when necessary.
    • New: We added a new Upsert Mode option in Premium SQL Server destination component, which supports configurations such as Full Upsert, Insert Only (existing records ignored), and Update Only (new records ignored).
    • New: Amazon Redshift Command Task, Amazon Redshift source and destination components now have support for output parameters, which makes it possible to receive output parameter values when necessary.
    • New: We added a new Upsert Mode option in Amazon Redshift destination component, which supports configurations such as Full Upsert, Insert Only (existing records ignored), and Update Only (new records ignored).
    • New: PostgreSQL Command Task, PostgreSQL source and destination components now have support for output parameters, which makes it possible to receive output parameter values when necessary.
    • New: We added a new Upsert Mode option in PostgreSQL destination component, which supports configurations such as Full Upsert, Insert Only (existing records ignored), and Update Only (new records ignored).
    • New: Google AlloyDB Command Task, Google AlloyDB source and destination components now have support for output parameters, which makes it possible to receive output parameter values when necessary.
    • New: We added a new Upsert Mode option in Google AlloyDB destination component, which supports configurations such as Full Upsert, Insert Only (existing records ignored), and Update Only (new records ignored).
    • New: Snowflake Connection Manager now supports specifying a database.
    • New: We added Command Separator support to Snow Command Task.
    • New: We added Command Separator support to Snowflake source and destination components when working with Pre&Post Commands.
    • New: Snowflake destination component now supports specifying Additional Bulk Copy Parameters.
    • Enhancement: Improved error handling in Snowflake components.
    • Update: Now you can manually provide the Project value in Google BigQuery Command Task, Google BigQuery Source and Destination Components.
    • Fixed: OAuth - Client Credentials authentication mode in SQL Server Connection Manager may not set the OAuth scope properly when working with the Dataverse Tabular Data Stream (TDS) endpoint.
  • Google Services
    • New: Google BigQuery Command Task component now supports creating new variables within its Error Handling page.
    • Update: Google Ads source component no longer supports Page Size property when working with v17 and above versions based on the recent API change.
    • Fixed: You may get "Invalid JWT: exp (expiration time) is not set" error in any Google service's Connection Manager when working with Service Account authentication.
    • Fixed: Maximum Records in Google Ads source component may not work properly.
    • Fixed: Customer Account ID in Google Ads destination component may not work properly.
  • HTTP/Web Services
    • New: We have added a new OAuth Client Credentials authentication option in HTTP Connection Manager, this option eliminates the need to use a token file when working with Client Credentials authentication.
    • New: We have added a new Static Token authentication option in HTTP Connection Manager.
    • New: OAuth Token Generator now supports specifying the JWT algorithm when working with OAuth 1 authentication mode.
    • New: OAuth Token Generator now supports specifying the JWT algorithm when working with OAuth 2 client assertion.
    • New: We added support for more JWT claim options in OAuth Token Generator when working with OAuth 2 client assertion.
    • New: We added support for working with a token file stored in Azure Blob Storage by specifying an Azure SAS URL for the Path to Token File option in HTTP Connection Manager when working with OAuth1 and OAuth2 authentication modes.
    • New: Google Service Account authentication mode in HTTP Connection Manager now supports using a service account.json key file.
    • New: Microsoft Graph destination component now supports <Link> and <Unlink> actions in Additional Bindings.
    • Enhancement: We have updated the default OAuth scopes when generating a Microsoft Graph OAuth token file in Microsoft Graph Connection Manager.
    • Enhancement: Better metadata detection when loading WSDL files in Web Service components.
    • Update: We have set POST as the default HTTP method in Web Service components.
    • Update: GraphQL components now use IntrospectionQuery to detect metadata.
    • Fixed: HTTP Requester data flow component may not send all the requests if the component has no downstream component attached.
    • Fixed: GraphQL source component may not send the argument value correctly when the provided value is in upper case.
  • JSON & XML Processing
    • New: JSON Extract/Source component now supports working with wild card node names by specifying node name as <ANY>.
    • New: We added support for importing XML documents that contain references of default namespace (xml) in XML components.
  • Message Queue Components
    • New: Azure Service Bus components now performs retries when throttling errors are received.
    • Update: We have updated Kafka client library to the latest version which resolves some vulnerability issues along with other enhancements.
    • Fixed: AMQP source component may not read all messages from the queue when working with some specific queue services.
    • Fixed: Azure Service Bus destination component may report "Object reference not set to an instance of an object" error when writing an empty message to EventHub.
  • Mail Components
    • New: SMTP task component and destination component now support sending emails with custom headers.
    • New: We added a new Throttle Rate option in SMTP Connection Manager.
    • New: We added a new Throttle Rate option in Email destination component that will be used when sending emails.
    • New: We added Logging support to Email Connection Manager.
    • New: Email destination component now supports sending emails with custom headers.
    • Fixed: Email source component may not discover the 'Archive' folder properly when working with a shared mailbox while working with Exchange Web Services protocol.
    • Fixed: Email source component may only output 1000 rows when using a Batch Size greater than 1000 while working with Exchange Web Services protocol.
  • Marketing Intelligence
    • Fixed: You may run into a FormatException when listing Accounts in Bing Ads source component while working with Campaign Management.
  • NoSQL Components
    • New: We added Batch Write support to Firestore destination component when working with Update, Upsert and Delete actions.
    • Fixed: In some rare situations, executing Productivity Pack components through an SQL Server agent job may get terminated with "Microsoft.Azure.Cosmos.ServiceInterop.dll" error.
  • Premium Components
    • New: We have added the following new functions to the Premium Derived Column component.
      • ComputeCrc32Hash
      • ComputeCrc64Hash
      • ComputeXxHash32
      • ComputeXxHash64
      • ComputeXxHash128
      • UnzipFileByIndex
      • UnzipFirstFile
    • New: We added the following new hash algorithms support in Premium Hash component.
      • Crc32
      • Crc64
      • XxHash32
      • XxHash64
      • XxHash128
    • New: We added support for more compression modes in Premium Data File components when working with Parquet file format.
      • Lzo
      • Brotli
      • LZ4
      • Zstd
    • New: We added file content download support in Premium OData source component when working with Edm.Stream column.
    • New: We added file content upload support tin Premium OData destination component when working with Edm.Stream column.
    • New: OData source and destination components now show any annotations available in the service's metadata.
    • New: Premium Lookup component now supports returning unlimited matches when the Max Number of Matches option is set to 0.
    • Enhancement: Premium OData components now support working with relative path value in the metadata link "@odata.context".
    • Update: Premium OData components now detect Dynamics CRM/CDS/Dataverse "mscrm.crmbaseentity" type field as raw JSON value field when working with a Dataverse/CDS/Dynamics 365 Customer Engagement connection.
    • Fixed: The sensitive properties in Premium SQL Server Connection Manager may not be properly marked so in parameterization.
    • Fixed: You may receive a KeyNotFoundException in Premium Excel source component when error output is enabled and the component has a column named with a space.
    • Fixed: Premium Data File source component may not read the column values correctly when column name contains dot while working with Parquet file format.
    • Fixed: Premium Data File source component may not read the array values correctly when working with Parquet file format.
    • Fixed: You may get an "Invalid Expression" error in Premium Derived Column when working with static numeric values that have all zeros after decimal point.
    • Fixed: Fuzzy Match in Premium Lookup may not work properly when working with one of the special match types like Address Match or First Name Match.
    • Fixed: You may run into "Object reference not set to an instance of an object" error in Premium Lookup when performing Fuzzy Match on empty string values.
    • Fixed: Premium Excel source component may report an "Arithmetic operation resulted in an overflow" error when working with some special files.
  • Premium File Pack
    • New: We added a Disabled Extensions option in FTPS Connection Manager, which can be used to turn off some FTPS extension features.
    • New: Premium File Transfer Task component now replaces invalid path characters in the source file name with the "%" character when downloading files from a cloud service to <<Local File>>.
    • New: We added Skip Commented Rows and Comment Character options to Premium Flat File source component.
    • Enhancement: We have a much improved session management when working with file upload/download via an FTPS connection.
    • Enhancement: We have made some performance improvements when working with file upload/download via an FTPS connection.
    • Update: "Use Legacy Group Exchange" option in SFTP Connection Manager now is disabled by default.
    • Fixed: Premium File Watcher Task may always report only the first file change if executed in a For Loop container when there are file changes happening to the file path.
  • Timing & Automation Components
    • New: Azure Functions Task component now supports creating new variables within Error Handling page directly.
  • REST Components
    • [General] New: We added Custom Headers support in REST Connection Manager.
    • Bill.com
      • Update: We have updated the base URL for Sandbox instance based on the API update.
      • Fixed: You may get a "System.ArgumentNullException" when listing organizations in Bill.com REST Connection Manager.
    • Ceridian Dayforce
      • New: We added Stage and Train Instance Type support in Ceridian Dayforce REST Connection Manager.
      • Enhancement: Updated application metadata.
    • Crelate
      • Enhancement: Updated application metadata.
      • Fixed: Writing to custom fields may not work properly in Crelate REST destination component.
    • Facebook Business
      • Update: We updated the default API Version to v22.0.
      • Update: We have removed the support of the public KingswaySoft OAuth App in Facebook Business REST Connection Manager.
      • Fixed: You may get NULL values in the virtual _LinkId field when working with Ads Insights object in Facebook Business REST source component while the Link Id Mode is set to Explicit.
    • Facebook Messenger
      • Update: We updated the default API Version to v22.0.
    • Freshdesk
      • New We added "Get Associated Tickets" endpoint support to Freshdesk REST source component.
      • Enhancement: Updated metadata for the 'Get All Tickets' endpoint.
    • Google Classroom
      • Enhancement: We have updated the default OAuth scopes when generating a Google Classroom token file.
    • Google Maps
      • New: We added Project ID support in Google Maps REST Connection Manager, which can be used to send the X-Goog-User-Project HTTP header.
    • Jira
      • New: We added Asset API support.
    • Jotform
      • New: We added EU and HIPAA Instance Type support in Jotform REST Connection Manager
    • Magento/Adobe Commerce
      • Fixed: You may run into "The signature is invalid" error when working with OAuth authentication mode in Magento/Adobe Commerce REST Connection Manager.
    • MailChimp
      • Enhancement: Better data type detection when working with MailChimp number type fields.
      • Fixed: MailChimp REST source component may report a System.ArgumentNullException when reading from "Member Activity Feed" object.
    • OpenAI
      • New: We added Batch writing actions support in OpenAI REST destination when working with createChatCompletion, createEmbedding, createCompletion actions.
      • Enhancement: Updated application metadata.
    • Paypal
      • Enhancement: Updated application metadata in Subscriptions object.
    • PowerBI
      • Enhancement: We have updated the default OAuth scopes when generating a Power BI token file.
    • RingCentral
      • Fixed: Pagination may not work properly in the RingCentral REST source component when working with Call Log object.
    • Salesforce Pardot
      • Fixed: Salesforce Pardot REST components might send non-stopping custom field discovery service calls when working with Prospect object while the target Salesforce Pardot instance has no Prospect custom fields.
    • Sendinblue/Brevo
      • Fixed: Sendinblue/Brevo REST source component may not output the records properly when working with certain endpoints.
      • Fixed: Sendinblue/Brevo REST destination destination may not write the multiselect values properly.
    • ServiceNow
      • New: ServiceNow REST destination component now supports sending the writing requests in Batch API.
      • New: We added PKCE OAuth authorization code flow support when generating a ServiceNow OAuth token file.
      • New: We added OAuth Client Credentials authentication mode support in ServiceNow REST Connection Manager.
      • New: We added OAuth JWT authentication mode support in ServiceNow REST Connection Manager.
      • Fixed: You may get "Unexpected character encountered" error when downloading _attachment file content from ServiceNow REST source component.
    • Shopify
      • Fixed: Shopify REST destination component may not work properly when working with "Creates a fulfillment for one or many fulfillment orders" action.
    • Slack
      • New: We have added a new Instance Type option in Slack REST Connection Manager.
      • New: We added OAuth authentication mode support in Slack REST Connection Manager.
      • Enhancement: We have updated the default OAuth scopes when generating a Slack API Token.
      • Fixed: You may get an "Output name can not contain period. admin.apps.approved is invalid" error when working with "admin.apps.approved" object in Slack REST components.
    • Smartsheet
      • New: We added support to output all sheets in a workspace as a flatten output when working with "Get Workspace" endpoint in Smartsheet REST source component.
      • New: Smarsheet REST source component now supports parameterizing the Endpoint to work with discovered Sheet objects dynamically.
      • New: Smarsheet REST destination component now supports parameterizing the Destination Object to work with discovered sheet objects dynamically.
    • Stripe
      • Enhancement: Updated application metadata.
      • Fixed: Stripe REST source component may not output the records correctly when working with "Retrieve a balance transaction" endpoint.
    • Zendesk
      • New: We added support for custom objects in Zendesk REST source and destination components when working with the Support API.
    • Zoho CRM
      • Update: We updated the API support to the latest version v7.
      • Fixed: You may run into login error when generating Zoho CRM OAuth token file while working with a Zoho CRM account in Canada data center.
      • Fixed: Testing Connection in Zoho CRM REST Connection Manager may report a gateway error when working with a Sandbox instance.
    • Zoom
      • Enhancement: Updated application metadata.

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

Sign up to receive notifications on software updates and enhancements.