What's New

SSIS Productivity Pack

Detailed changelog for every release of KingswaySoft SSIS Productivity Pack

Version 23.3.1 - Dec 21, 2023

This is a new service release, which comes with the following updates and fixes:

  • Fixed: Azure Service Bus Destination - When using a relatively large Batch Size setting in the Azure Service Bus destination component, you might receive the error "The message is larger than is currently allowed".
  • Fixed: Google BigQuery - Pagination may not work properly when using the Query Object Type.
  • Fixed: SMTP Task - The SMTP task may not properly dispose of the connection after execution, which can cause connection limit errors when the task is running within a loop container.
  • Fixed: Premium Lookup - The tooltip in the columns page might prevent access to the Comparison Settings configuration.
  • Fixed: Data Spawner/Anonymizer - The Data Spawner and Data Anonymizer components have a high collision rate, which can result in duplicate data being generated at a relatively high rate.
  • Fixed: Data Anonymizer - The Data Anonymizer component might produce different results between the installations of different release builds for columns that have their Source Affinity set to true. This should be seen as a breaking change of the source affinity feature, as the component would now produce a different result from all previous versions for columns that have a random seed specified while its source affinity option is set to true, due to the newly introduced hash algorithm which is much more resilient and consistent going forward.
  • Fixed: ClickUp - When a custom field contains a space character in the field name, the REST destination component using the ClickUp connection may fail with an error while creating a record.

Version 23.3 - November 29, 2023

This release comes with the following updates and enhancements:

  • New Components
    • New API Framework - Microsoft Graph
      • Microsoft Graph Connection Manager
      • Microsoft Graph Source
      • Microsoft Graph Destination
    • Message Queuing
      • MQTT Connection Manager
      • MQTT Source
      • MQTT Destination
      • MQTT Task (Added in Message Queue Task)
    • Security Management
      • Azure Key Vault Connection Manager
      • Azure Key Vault Task
      • AWS Secrets Manager Connection Manager
      • AWS Secrets Manager Task
    • New services in the REST framework
      • Extensiv / 3PL Central
      • Microsoft Planner
      • WebEx
  • Data Quality and Comparison
    • Address Verification
      • New: We added support for the enhanced match option in Address Verification component.
  • Big Data
    • Enhancement: Snowflake connection manager can take the fully-qualified domain name for the Account option without causing an error.
    • Fixed: When reading HL7 files that contain custom segments, the EDI source component might fail with an error about not allowed segments.
  • Cloud Storage
    • New: Azure Blob Storage destination component now supports a new Etag output column for Create/Update actions.
    • Fixed: When using the Amazon S3 Source component to download a file using the chunk size "0", the component might fail with an error: "KingswaySoft.IntegrationToolkit.AmazonStorageServices.AmazonS3ServiceException: The From or To parameter cannot be less than 0".
    • Fixed: When working with an Amazon S3 connection, the Premium File System source component reading list-objects may not page through the records properly.
    • Fixed: When using an Azure Data Lake Storage source component, the file browser window in the Premium File Transfer task might report a Newtonsoft.Json.JsonSerializationException error related to datetime value conversion for the creationTime property.
  • Google Services
    • Fixed: When working with the Google BigQuery destination component, writing to a repeated field under a repeated field might not work properly.
  • HTTP/Web Services
    • New: OAuth token file now supports conditional encryption on custom/additional parameters.
    • Fixed: Web Service destination component may not load certain parameters properly when the parameter is deep in expansion.
  • JSON & XML Processing
    • Fixed: XML source component might fail with a NullReferenceException in the PreExecute stage when there is a KVP configuration that contains complex objects (OutputType=None).
  • Mail Components
    • New: You can now use one Email destination component to create emails with attachments, which used to require multiple destination components.
    • New: SMTP task now supports a new NTLM authentication option.
    • Enhancement: SMTP task now supports pipe-delimited attachment files configuration  for a much more simplified multi-attachment configuration.
  • Message Queue Components
    • New: We have added a new "Get Message Count" action in the Premium Message Queue Task.
    • Fixed: Retry on intermittent errors option might not work properly when working with an Azure Service Bus destination component.
  • NoSQL
    • Redis
      • New: We added support for JSON data type in Redis destination component.
      • Fixed: When working with the list datatype in Redis source component, it may not return any records.
      • Fixed: Redis destination component might fail with a NullReferenceException when an input for _value field is not provided if using the No Pivoting mode.
      • Fixed: Redis source component might fail with a "RedisServerException: WRONGTYPE Operation against a key holding the wrong kind of value", when trying to read string type values for the keys of MixedType/StringType/* with batch size = 1.
      • Fixed: When working with SortedSet data type in a Redis destination component, it might fail with an InvalidCastException.
      • Fixed: When reading list-type values with the pivot mode and an invalid key, the component fails.
  • Premium Data Flow Components
    • New: Premium Excel destination component now provides an option to disable styling on columns.
    • New: We have added the following functions to the Premium Derived Column component.
      • AdvancedEncryptUsingDES
      • AdvancedDecryptUsingDES
      • AdvancedEncryptUsingAES
      • AdvancedDecryptUsingAES
      • AdvancedEncryptUsingRC2
      • AdvancedDecryptUsingRC2
      • AdvancedEncryptUsingTripleDES
      • AdvancedDecryptUsingTripleDES
      • AdvancedEncryptUsingRijndael
      • AdvancedDecryptUsingRijndael
      • EncryptUsingDES
      • DecryptUsingDES
      • EncryptUsingAES
      • DecryptUsingAES
      • EncryptUsingRC2
      • DecryptUsingRC2
      • EncryptUsingTripleDES
      • DecryptUsingTripledes
      • EncryptUsingRijndael
      • DecryptUsingRijndael
    • New: The Premium Derived Column component now provides support for PBKDF2 function, which can be used to generate correct key sizes from a string password. This PBKDF2 function can be used for the new encryption functions.
    • Enhancement: Premium Slowly Changing Dimension destination component now report the concerning output column name if the incoming data is causing "The value is too large to fit in the column" error. 
    • Update: We have deprecated some old encryption and decryption functions in the Premium Derived Column component.
    • Fixed:  When using the Ignore errors option in the Premium Conversion component, the component might still fail when there is actually a conversion error.
    • Fixed: Premium Hash component may not handle empty input values properly in some occasions.
    • Fixed: Command text box in the Premium ADO.NET source or destination component might display overlapped characters when working with full-width characters such as Chinese and Japanese.
  • Premium File Pack
    • New: Premium Flat File components will do an auto-detect of field length upon file import.
    • Fixed: Double quote characters were not properly escaped in the Premium Flat File destination component.
  • REST components
    • ADP
      • New: We have added support for a new endpoint ValidationTables > Details of a specific record in the validation table - Jobs.
    • Brevo/Sendinblue
      • Update: We have rebranded the service under the new name "Brevo/Sendinblue".
      • Update: We have updated its API to the latest metadata. All objects and service endpoints should be mapped to the new service endpoint structure.
    • Constant Contact
      • Fixed: Pagination does not work properly for Email Reporting Object.
      • Fixed: The EmailReporting > Get an Email Campaign Activity Stats Reports endpoint does not return any values in the REST source component.
    • eBay
      • Fixed: When using an eBay REST connection, REST components might not send the correct Instance Type information when making a request.
    • ElasticSearch
      • New: We have added support for  Elasticsearch Data Stream API. 
      • Fixed: When working with an Elasticsearch connection that uses AWS signature authentication, the Elasticsearch source component might fail with an error "The request signature we calculated does not match the signature you provide".
    • Facebook Business
      • Update: We have updated the entire API to the latest metadata.
      • Update: We have removed some deprecated fields, this includes the removal of ad_strategy_group_id and ad_strategy_id fields fields when working campaigns object. 
    • Freshservice
      • New: We added support for custom object endpoints.
    • PayPal
      • New: We support support for subscription object in both REST source and destination components when working with a PayPal connection.
    • Shopify
      • Update: We have updated the entire API to its latest version along with all metadata updates.

Version 23.2 - September 8, 2023

This release comes with the following updates and enhancements:

  • General
    • 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.
  • New Components
    • New API Framework - GraphQL
      • GraphQL Connection Manager
      • GraphQL Source
      • GraphQL Destination
    • Automation
      • Windows Command Task
    • JSON and XML Processing
      • JSON Extract Task
      • XML Extract Task
    • Marketing and Marketing Intelligence
      • Google Ads Destination Component
    • Premium File Pack
      • SMB Connection Manager
    • New services in the REST framework
      • Blackbaud
      • Emfluence
      • Google Classroom
      • Google People
      • Google Search Console
      • Google Tag Manager
      • OpenAccounting
      • Paycor
      • ZohoExpense
      • ZohoInvoice
      • ZohoSheet
  • Big Data
    • New: We added a new Suppress Value Conversion option to the Google BigQuery source component, which can help read rows that contain Infinity values, which otherwise could raise an "Input string was not in the correct format" error.
    • Enhancement: We have some optimization to the Google BigQuery Command Task so that we should only request the minimum number of rows depending on the chosen Output Type option.
    • Fixed: In Google BigQuery Command Task, the 'Create Query Job' option is not always respected for all 'Output Types'.
    • Fixed: Google BigQuery Command Task may not properly re-populate the 'Single Row Selection Mode' option upon re-opening.
  • Cloud Storage
    • New: We added SAS Token authentication support to Azure Data Lake Storage Connection Manager.
    • New: We added IAM Role support for the Amazon S3 connection manager.
    • Fixed: OneDrive connection manager was not able to generate a request/refresh token when working with a personal account.
  • Data Warehousing
    • Enhancement: We have updated Snowflake connection manager to report a better message when there is a problem authenticating with a third-party identity provider such as Okta.
    • Fixed: We fixed the intermittent "Npgsql.NpgsqlException: Received backend message CommandComplete while expecting ParseCompleteMessage" errors when using Preview function in PostgreSQL, Redshift source and command task components.
    • Fixed: The timeout configuration in Snowflake Command Task may not work properly.
  • Encryption and Compression
    • Enhancement: We have made the PGP New Key window more clear by separating different configurations into two groups.   
  • Google Services
    • New: We added 4 new Google services including Google Classroom, Google People, Google Search Console, and Google Tag Manager.
  • HTTP/Web Services
    • New: We now provide a new certificate chooser window that can be used to select a certificate from Windows certificate store.
    • Enhancement: Our In-app authentication process is now powered by the WebView2 engine, which should work more reliably with some modern services that require the latest browser installations. This enhancement is implemented across all OAuth-based services within SSIS Productivity Pack.
    • Enhancement: We made some important concurrency handling which can help HTTP-based service calls be more efficient. Such optimization can avoid socket exhaustion or concurrency-related errors that might occur in some cases.
  • JSON & XML Processing
    • New: We added a new JSON Extract Task component which can be used as a control flow task to extract data from a JSON file.
    • New: We added a new XML Extract Task component which can be used as a control flow task to extract data from an XML file.
    • New: JSON Extract component now supports upstream columns as root output key fields.
    • New: We have added a new "Node Names Are Case Insensitive" option to JSON Source, JSON Extract, XML Source and XML Extract components.
    • New: We now support reading from an XML node that has string literals along with other child XML nodes as siblings.
    • New: We have a new IsRepeated node configuration in XML Source and Extract components. Without the option, the source component could return NULL values that might be incorrect in some cases.
    • Enhancement: In XML Merger and Destination components, we have removed the IsStandalone checkbox option, and have it replaced with a new 3-item dropdown list named as StandaloneMode. In doing so, we added a new option DontShow, which can be useful for the case where the standalone declaration is not needed at all.
  • Mail Components
    • New: We have added a new FIPS Mode option to SMTP connection manager, which can be used to force some FIPS compliance-related options.
    • New: We have added a new Ignore Certificate Errors option to SMTP connection manager, which can be used to ignore those SSL certificate-related errors.
    • Enhancement: We have updated our SMTP connection manager to report a better error message when the authentication fails.
  • Marketing Intelligence
    • New: We added support for a new Authorization Server URL option for OAuth token generation in Bing Ads connection manager.
    • New: We have added a new Google Ads destination component, which allows you to perform write operations when working with a Google Ads connection.
    • New: We added Filter Expression support when working with Google Analytics source component.
    • Fixed: customerAccountID and some other properties were not parameterizable in Google Ads source component.
  • Message Queue Components
    • New: We have added a new "Use Shared Session" option to the Kafka Source component. This feature, when enabled, can prevent a session from being closed, so it can be used for the situation where the component runs within a loop container.
    • New: We have added a new "Close Shared Session" option in the Premium Message Queue Task component when a Kafka connection is used. This action can be used to work with the "Use Shared Session" option above in the Kafka Source component, it can help close shared session.
    • New: We have added a new "Receive Message Timeout" option to the Kafka Source component.
    • New: We added a new Commit action in Kafka destination component, along with the necessary supporting options.
    • Update: We have updated the IBM MQ client library from v8 to the latest v9.3 to accommodate the new features that might be required.
    • Update: We had various UI updates in IBM MQ connection manager for better alignment and spacing.
    • Update: We had various UI updates in IBM MQ source component for better alignment and spacing.
    • Fixed: Kafka listener mode can randomly stop listening early in Kafka source component or Premium Message Queue Task (if a Kafka connection is used).
    • Fixed: Premium Message Queue Task UI might crash after selecting an out-of-box Message Queue connection manager.
    • Fixed: After upgrading from v21.x to v23.1, packages that contain Azure Service Bus components might become unopenable.
  • NoSQL Components
    • New: We have added a new "Node Names Are Case Insensitive" option to CosmosDB Source, Couchbase Source, and MongoDB Source components.
    • Fixed: When working with Couchbase, creating records in for loop container could result in an "Cannot access a disposed object" error.
    • Fixed: When working with a List datatype field in the DynamoDB destination component, it might send the field value incorrectly using S type.
    • Fixed: Redis connection manager might display the Password field in a plain text format.
  • Premium Data Flow Components
    • New: Premium Derived Column component now includes support for the following new functions:
      • In()
      • NotIn()
      • InStringArray()
    • New: Premium ADO NET destination component now supports Bulk Update/Upsert/Delete and Full Sync actions for IBM DB2 if the IBM data provider is used.
    • Update: In our Premium Excel Source component, we have added a new Suppress file-not-found errors option.
    • Update: In our Premium Excel Source component, we have added a new Suppress sheet-not-found errors option.
    • Update: The PDF source component can fail with a confusing error message when we try to read an out-of-range TableIndex. We are now reporting a better error message when this occurs.
    • Fixed: When working with the Filter parameters in the Premium Service Lookup component, the eclipse button might cause the UI to crash with certain filter conditions.
    • Fixed: Premium ADO NET command task editor UI might crash when trying to expand the object tree if another thread creates a pending non-committing transaction that attempts to make schema changes.
  • Premium File Pack
    • New: We have added support for SMB shared path as a new connection manager. The connection manager works similarly to a local file connection, but it makes it offers the ability to provide a login user credential in the connection manager.
    • New: We have added a new "Use BOM Encoding" option to the Premium Flat File Destination Component, which allows you to specify whether the generated .csv file should use BOM encoding.
    • Fixed: When trying to copy CreationTime to an SFTP connection using the Premium File Transfer Task, you might receive a NullReferenceException related error that says "An error occurred writing '' to the 'CreationTime' property".
    • Fixed: When trying to delete a file that does not exist using the Premium File Transfer Task, it might still report an error even though the component has been configured to ignore errors.
  • REST components
    • General
      • Fixed: After switching the connection manager from one service to a different one in a REST source component, the component might return a NullReferenceException upon re-opening. 
    • ADP
      • New: We added pagination support for the Job Requisitions object.
      • New: We added pagination support for the Worker Demographics object.
    • Authorize.NET
      • Fixed: When working with the Transaction Reporting object, the query parameter may not be sent in a correct format when it contains a datetime value.
    • BigCommerce
      • Update: We have some metadata updates to the order create operation. The updates include some of the newly introduced fields, such as Date_created, External_order_id, etc.
      • Fixed: When working with a BigCommerce endpoint that supports child input, you might run into an error message similar to "The 'Order V2-Orders' object is not mapped to an Input".
      • Fixed: The Order Consignments object was missing in the REST BigCommerce source component.
    • DocuSign
      • Update: We updated 'Accounts->Get account settings information' endpoint to return 10 more fields, including accountUISettings, allowAgreementOrchestrations, allowIDVLevel1Trial, allowOrganizationDocusignMonitorLite, enableInboxBrowseViewsPoweredByElasticSearch, enableInboxRelevanceSort, enableSearchServiceAzureUri, and useNewEnvelopeSearchOnlyWithSearchTerm.
      • Fixed: Some child objects might be missing for some DocuSign objects in the REST destination component, when they are 3 levels or more deep in the hierarchy.
    • Freshservice
      • New: We added filter parameter support for the Tickets object.
      • Update: We have updated the service metadata to the latest version available, which contains  a massive number of updates including many newly introduced service endpoints, objects, and fields.
      • Fixed: Custom checkbox field might be detected as an incorrect string datatype.
    • Jira
      • New: We have added support for a new Personal Access Token authentication option.
    • Magento
      • New: We have added OAuth support for Magento REST connection manager.
      • Update: We have updated some of the object and service endpoint names.
    • Microsoft Teams
      • New: We have added support for two new fields (assignedLabels and preferredDataLocation) when working with the Update action of "Group".
      • Update: We have added some missing fields for Update action of "Group".
      • Update: We have removed batch support for Add Member, Remove Member, Add Owner, and Remove Owner actions.
    • Okta
      • New: We added support for a new Subdomain option in Okta REST Connection Manager, which can be used to support multiple instances when applicable.
    • RingCentral
      • Fixed: When working with the JWT authentication option in a RingCentral REST connection manager, it might report an "Invalid Authorization Header" error.
    • ServiceNow
      • New: We have added a new "Ignore Null Values" option in the ServiceNow REST destination component which can be used to prevent empty value overwrite. 
    • Shopify
      • Update: We have made some updates to Shopify metadata system in which we have added a number of new fields to Shopify components.
      • Fixed: Shopify REST connection manager might report a successful connection even though there are invalid configurations with the connection manager.
      • Fixed: in Shopify REST source component, the line_items values may not be returned from Orders>Abandoned Checkouts object.
    • Xero
      • New: We have added support for Asset API in Xero REST components.
      • Fixed: When working with Xero REST source component, the _LinkId columnd might return Null value when reading grandchild objects with LinkId mode set to Explicit Id.
    • Zoho Books
      • New: We have added support for custom fields in both Zoho Books REST source and REST destination components.

Version 23.1.1 - May 19, 2023

This release is mainly a service release, which comes with the following updates and fixes:

  • Big Data
    • Fixed: Some field might be missing in the designer when writing to X12 EDI format file.
    • Fixed: CDM source component may make repetitive failed service calls to retrieve the list of partitions when the specified path does not exist for the chosen ADLS connection. 
  • Cloud Storage
    • Fixed: When downloading an empty file from an Azure Data Lake Storage Connection Manager with Fail Bulk Download Behavior option enabled, you might run into an error complaining about the file's etag has changed.
    • Fixed: Azure Blob Storage source component may not properly download the file content when not all fields are selected in the component.
    • Fixed: Azure Blob Storage source component may not return any metadata field values if none of the x-ms fields is selected.
  • HTTP/Web Services
    • Fixed: In certain situations, HTTP service calls could possibly create a large number of concurrent open sockets, which could crash the runtime.
  • JSON & XML Processing
    • Fixed: When writing to an XML file in a XML Merge or XML Destination component that involves a parent-child relationship where the component's Value Null Mode is set to xsi:nil but no namespaces have been specified, the component might report a NullReferenceException error during runtime.
  • Message Queuing
    • Kafka
      • New: A new 'Receive Message Timeout' property has been added to the Kafka source component.
      • Fixed: In some occasions, you may run into an unexpected "Confluent.Kafka.KafkaException: Local: Broker transport failure" error.
  • Premium ADO.NET
    • Fixed: Command Timeout setting may not be applied to the metadata calls during design time.
  • Premium Data File
    • Fixed: When creating a Paraquet file that has a smallint field, the created file might not be readable by other Parquet utility or software programs.
  • REST Services
    • Acumatica
      • Fixed: Custom endpoints may not be properly discovered.
    • Clickup
      • Fixed: The parent field was missing in the GetFilteredTeamTasks operation.
      • Fixed: In the GetTasks operation/service endpoint, the subtasks query parameter was missing.
      • Fixed: Array type filter parameters may not been sent correctly.
      • Fixed: Pagination may not work properly in the source component when reading from the Tasks object.
    • ConstantContact
      • Fixed: When using the Bulk Activities > Import Contacts using a JSON Payload operation, its child input is redudant.
    • DocuSign
      • Fixed: allowEditingEnvelopesOnBehalfOfOthers and related fields were missing.
    • Facebook
      • Fixed: When using the Events > Create Event By OfflineConversionDataSet operation, the data filter is sent as a comma-separated string instead of as a JSON string as required.
      • Fixed: When using the Events > Add Event by AdsPixel operation, the data filter is sent as a comma-separated string instead of as a JSON string as required.
    • Freshservice
      • Update: Basic authentication option has been removed as it has been deprecated by the vendor.
    • LinkedIn
      • Update: 'UGC Post API' has been removed and it has been moved to the 'Post API'.
      • Update: 'Share API' has been removed and it has been moved to the 'Post API'.
    • ServiceNow
      • Update: Update action is now using the PATCH method instead of PUT previously. This is to be consistent with general industry standard.
    • Shopify
      • Fixed: 'sort_value' in Collect object should be a string field.
      • Fixed: The compare_at_price field should be using a data type of decimal instead of nvarchar.
    • SmartSheets
      • Fixed: The default batch size for some operations might be too high to cause URL length related errors during runtime.
      • Fixed: A default row location was not set when the option is not specified in the destination component, which can cause the writing to fail.
    • TikTok
      • Update: As per TikTok documentation, we have updated the create a US lead download task operation to create a lead download task.
      • Update: As per TikTok documentation, the Leads > Create a non-US lead download task endpoint has been removed.
    • Trello
      • Fix: A couple of custom field changes, including changing id to _id for the Get the options of a Dropdown Custom Field operation and adding the idValue field for the Get the Custom Field Items for a card operation.
    • Zoho Books
      • New: We have added support for Japan data center.
    • Zoom
      • Update: JWT authentication option has been removed.
    • Zuora
      • Update: WSDL version has been updated to 124 for Create and Update actions.
      • Fixed: X-Zuora-WSDL-Version header was missing for Delete action.
      • Fixed: X-Zuora-WSDL-Version header was missing for non-custom objects, when using a bulk action by having a BatchSize greater than 1.

Version 23.1 - March 17, 2023

This release comes with the following updates and enhancements - Note that this will be our last version that supports SSIS 2008 (SQL Server 2008):

  • General
    • 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: KingswaySoft License Manager might report an incorrect grace period when the license is running under the grace terms.
  • New Components
    • Big Data
      • Tableau Hyper Connection Manager
      • Tableau Hyper Publish Task
      • Tableau Hyper Source
      • Tableau Hyper Destination
    • NoSQL Components
      • Couchbase Connection Manager
      • Couchbase Source
      • Couchbase Destination
    • Premium Data Flow Components
      • Premium Recordset Source
    • Premium File Pack
      • Premium File Watcher Task
    • New services in the REST framework
      • Airtable
      • Authorize.NET
      • BambooHR
      • Duo Security
      • Emarsys
      • Google Calendar
      • Google Maps
      • OneLogin
      • Ping Identity
      • RingCentral
  • Big Data
    • New: We added Output Time Zone support to CDM source component.
    • New: Premium Data File destination component now supports "Skip Write On No Rows" option.
  • Cloud Storage
    • New: We added "Bulk Download Behavior" support to Azure Data Lake Storage Connection Manager when working against ADLS Gen2, the property can be used to detect or prevent file modification when downloading the file.
    • Fixed: You may run into a 403 Forbidden error when listing items in File Chooser for a connection that uses Azure Storage Emulator.
    • Fixed: Azure Blob destination component may fail with "403 Server failed to authenticate the request" error when If-Modified-Since filter is provided.
    • Fixed: You may get the error "XML specified is not syntactically valid" in Azure Blob destination component when If_None_Match is provided while the file already exists in Azure Blob.
    • Fixed: Azure Blob destination component may report "An item with the same key has already been added" error when working with Append/Page blobs.
    • Fixed: Azure Blob destination component may not set the "Content-Type" properly when working with Append blobs.
    • Fixed: Azure Files destination component may not send the x-ms header values properly.
  • Data Warehousing
    • New: We added a "Fail On No Affected Records" option to the PostgreSQL and Google BigQuery destination components. When enabled, Update or Delete action would fail if no matching rows are found in the target database table when Row-By-Row writing mode is chosen, which is the default behavior in previous versions. This can now be suppressed by unchecking this option, in which case the the component would succeed even no matching records were found for the intended action (Update or Delete).
    • Fixed: You may receive an error "cannot write DateTime with Kind=Unspecified to PostgreSQL type 'timestamp with time zone'" when working with PostgreSQL type 'timestamp with time zone' in PostgreSQL components.
    • Fixed: For some particular PostgreSQL servers, Upsert action in PostgreSQL destination component may fail with an error "Version string portion was too short or too long".
    • Fixed: Connecting to PostgreSQL through SSL Tunnel may fail with an error "An attempt was made to access a socket in a way forbidden by its access permissions".
  • Google Services
    • Fixed: Google Sheets destination component may write empty string values to unmapped columns when performing SPREADSHEETS.SHEETS.VALUES - UPDATE action.
  • HTTP/Web Services
    • New: We added support for Windows Integrated Authentication authentication mode in HTTP Connection Manager.
    • New: We added a "Drop Authorization Header On Redirects" property to HTTP Connection Manager, 
    • Enhancement: Web Service components no longer encode data in a CDATA Section.
    • Enhancement: Better metadata detection when loading WSDL files in Web Service components.
    • Update: Default "Field Expansion Depth" is now set to 5 in Web Service components.
    • Fixed: You may get "Status Reason: NotFound" error when loading some specific WSDL files in Web Service components.
    • Fixed: Loading WSDL file in Web Service components with an HTTP Connection Manager may not use the specified authentication mode correctly.
  • JSON & XML Processing
    • New: We added a "Link Ids Are Scrambled" option to JSON/XML Merge/destination component. When the option is disabled, the component will have some substantially better performance when working with multi-level JSON/XML document structure provided the link ID values inside the document are not scrambled.
    • Enhancement: Better error handling and reporting when importing an invalid JSON file to JSON Extract/Merge/source/destination component.
    • Update: Default Value Null Mode is now set to "xsi:nil" in XML Merge/destination component.
    • Fixed: HTTP Connection Manager used in an XML destination component may not send the specified credentials properly when the Credentials authentication mode is used.
    • Fixed: You may run into "System.Exception: "Is Repeated" node does not support sharing relative path with other nodes" error in JSON Extract/source component when working with repeated array of values in an array of objects.
  • Marketing Intelligence
    • New: Customer Account Id in Google Ads source component now supports listing account hierarchies.
    • Update: We updated the default API Version to latest version (v13) in Google Ads Connection Manager.
    • Update: Login Customer Id property in Google Ads Source has been updated as Customer Account Id.
  • Mail Components
    • New: We added OAuth 2 authentication support to SMTP Connection Manager.
    • New: We added OAuth 2 authentication support to IMAP and POP3 protocols in Email Connection Manager.
    • New: SMTP Connection Manager provide a Test Connection button now.
    • New: We added "Send Email By ID" action support to Email destination component when working with EWS protocol.
    • New: Email destination component now outputs Change Key ID when working with "Upload Message" and "Add Attachment" actions through an EWS connection.
    • Enhancement: "Send Raw Email" action in Email destination component has some updated metadata when working with EWS protocol.
    • Update: SMTP Task no longer requires Reply To Address to be specified.
    • Fixed: "Is Body HTML" property in SMTP Task may get unchecked when upgrading from a prior version to a recent version.
  • Message Queue Components
    • New: Azure Service Bus now supports working with TCP proxy.
    • New: We added "Move to Dead Letter" action support to Azure Service Bus destination component.
    • Enhancement: Better error handling when an invalid queue name is provided in Azure Service Bus source component.
    • Fixed: Operation Timeout setting may not work properly in Azure Service Bus connection manager.
    • Fixed: Azure Service Bus source component may output different number of records when working with a Dead Letter queue.
    • Fixed: "Receive and Delete" mode in Azure Service Bus source component may output incomplete result when working with a Dead Letter Queue.
    • Fixed: You may run into "The requested session cannot be accepted" error when working with session required queues in Azure Service Bus source component.
  • NoSQL Components
    • Fixed: MongoDB source component may not output datetimeoffset value correctly when Output Timezone is set to Local.
    • Fixed: MongoDB destination component may not escape some input values properly.
    • Fixed: You may get "JSON reader was expecting ':' but found '","'." error in MongoDB destination component when working with a value that contain quote characters.
  • Premium Data Flow Components
    • New: Premium Derived Column component now includes support for the following new functions:
      • FileExists()
      • FolderExists()
    • New: We added a "Fail On No Affected Records" option to Premium ADO NET destination component. When enabled, Update or Delete action would fail if no matching rows are found in the target database table when Row-By-Row writing mode is chosen, which is the default behavior in previous versions. This can now be suppressed by unchecking this option, in which case the the component would succeed even no matching records were found for the intended action (Update or Delete).
    • New: Premium ADO NET destination component now supports Bulk Update/Upsert/Delete and Full Sync actions against Oracle database though ODP.NET Managed data provider.
    • Update: Post Command in Premium ADO NET, PostgreSQL, Amazon Redshift, and Google AlloyDB source/destination/task component is split into Success Post Command and Error Post Command.
    • Update: Pre Command in Premium ADO NET source/destination component is moved to be the first action of the Execute method, rather than being executed in the pre-execute stage previously.
    • Update: "Autofit Column Width" property in the Premium Excel destination component now takes decimal percentage values.
    • Fixed: Premium ADO NET destination component would silently truncate the string values when the input value length is larger than the target column length.
    • Fixed: Premium ADO NET destination component may not write numeric values properly when working with IBM DB2 database.
    • Fixed: Temporary tables may not get dropped properly if working with Bulk Update/Upsert/Delete and Full Sync actions in the Premium ADO NET destination component against Oracle database through ODP.NET Unmanaged data provider.
    • Fixed: The big numbers with length of 16 and more may get rounded in the Premium Derived Column component, for instance, value like 321825482218.2038 may get output as 321825482218.2040 previously.
    • Fixed: Premium Derived Column component may report an "Invalid binary expression specified" error when testing expression with changed test value.
    • Fixed: Output columns in a Premium Service Lookup component may get dropped when it is copied and pasted as a new component.
    • Fixed: Premium Service Lookup component may report HRESULT: 0xC0047072 error when replacing an input column in Output Columns page.
    • Fixed: Premium Lookup component may reports SSIS validation error when the upstream column's data type has changed.
    • Fixed: You may get an upgrade error which complains about duplicate output alias '_average_similarity_score'" in the Premium Lookup component when the data flow task was created using an earlier version of SSIS Productivity Pack (v21.2.1) that has multiple Premium Lookup components chained together, but upgraded to v22.1.
  • Premium File Pack
    • Fixed: You may get null values on CreationTime property when working with an SFTP connection in Premium File Pack components.
    • Fixed: Premium Flat File source component may not output the data row properly when the data row starts with "#" character.
    • Fixed: You may run into an "Object reference not set to an instance of an object" error in Premium Flat File source component when reading from the <File Content in variable> option.
    • Fixed: Premium Flat File source component may report "The method or operation is not implemented" error when loading metadata using the <File Content in variable> option.
    • Fixed: You may get "Already connecting to the server" error when running multiple Premium File Pack components simultaneously while working against the same SFTP server.
    • Fixed: Premium File Pack components may report an "Invalid character: '_'." error when performing Advanced Filtering with an SSIS variable and the variable name contains "_".
  • Premium Task
    • New: We added renaming support to Azure Blob/Google Cloud Storage/S3 service in Premium File Properties Task.
    • Update: Premium File Properties Task now outputs the variable default value when reading a datetime type property and output to a datetime type variable.
  • REST components
    • General
      • New: We added a "Link Ids Are Scrambled" option to REST destination component when the component requires multiple inputs. The option is disabled by default, which can be used to improve the performance when working with multi-level JSON structures that have unscrambled ID values.
    • Acumatica
      • New: We added Company support to OAuth authentication mode in Acumatica REST Connection Manager, it can be used to retrieve the API reference of a certain company.
    • Ceridian Dayforce
      • Fixed: "IsValidateonly" field is missing in Ceridian Dayforce REST destination actions.
    • Facebook Business
      • New: We added filtering parameter support to "Read Lead By Ad" and "Read Lead By LeadgenForm" endpoints in Facebook Business source component.
      • Update: We updated the default API Version to v16.0.
    • Facebook Messenger
      • Update: We updated the default API Version to v16.0. 
    • Freshservice
      • New: We added support for discovering type fields when working with Asset object in REST source/destination component of a Freshservice connection.
    • LinkedIn
      • New: We added various new API support including Post, InMailContents, Conversation Ads, Images and Videos.
      • Update: LinkedIn REST components now use the new versioned APIs.
      • Fixed: LinkedIn REST destination component may report an "object is not mapped to an input" error when working with an action that has child inputs.
    • Microsoft Teams
      • Enhancement: Updated metadata for Shift object.
    • Pipedrive
      • Enhancement: Better handling when downloading files from Pipedrive REST source component but the file download url is not found.
      • Enhancement: Updated metadata.
      • Fixed: Discovering custom fields in Pipedrive REST source/destination component may not perform paging properly.
    • ServiceNow
      • New: ServiceNow REST source component now supports reading from database views.
      • Update: ServiceNow REST source/destination component no longer reports errors at design time when the connection user doesn't have permission to the data_policy table.
    • Shopify
      • New: Shopify REST source and destination component now support working with collection_reference, list.collection_reference and money types of meta fields.
      • New: We added Fulfillment Order object support to Shopify REST destination component.
      • Enhancement: Updated metadata for Product/Order/Fullfilment/Metafield object.
      • Fixed: Updating a metadata field to NULL may not work properly in Shopify REST destination component.
      • Fixed: Reading metadata field values at runtime may not perform pagination properly in Shopify REST source component.
    • Square
      • Enhancement: Updated metadata.
      • Update: We have updated our KingswaySoft Square OAuth app to the latest API version.
      • Fixed: Square REST source component may not send array type filter parameter values properly.
    • SurveyMonkey
      • Enhancement: Updated metadata for "Survey Page Question" object.
    • TikTok
      • Update: We have updated the TikTok REST components to use the latest v1.3 API endpoints. Existing components may require reconfiguration since TikTok v1.3 API is dramatically different from v1.2 API and TikTok v1.2 API will be deprecated in August, 2023.
    • WordPress
      • Fixed: You may run into error "startIndex cannot be larger than length of string. Parameter name: startIndex" when loading objects in Wordpress REST source/destination component if the target Wordpress instance has some special third-party plugins installed.
    • Xero
      • Fixed: "If-Modified-Since" filter parameter was missing in Xero REST source component.
    • Zoom
      • New: We added "Server-to-Server OAuth" authentication support to Zoom REST connection manager.
    • Zuora
      • New: We added Invoice Items object support in Zuora REST destination component.
      • Update: We updated X-Zuora-WSDL-Version header to the latest 124 version when working with Query in Zuora REST source component.

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