What's New

SSIS Productivity Pack

Detailed changelog for every release of KingswaySoft SSIS Productivity Pack

Version 20.2.1 - December 10, 2020

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

  • [General] Enhancement: We added the ability to toggle numeric fields to string DT_WSTR(32) and DT_WSTR(64) data types in Source components that support data type toggling. This is helpful when string data type is more appropriate.
  • Data Warehousing
    • Fixed: Snowflake Destination component may report “The number of files exceeds the 1,000 limit” error when Bulk Copy a large number of records to Snowflake.
    • Fixed: You may get “Timestamp is not recognized” error when using Bulk Copy in Snowflake Destination component.
    • Fixed: You may run into KeyTooLongError when Bulk Copy using a temp table in Snowflake Destination component.
  • Encryption and Compression Tasks
    • Fixed: Deflate and Gzip compression formats in Compression Task may error out when the file is great than 2 GB.
  • Mail Components
    • Fixed: Email Connection Manager may report “The specification of a mailbox with the public folder root is invalid” error when testing connection using Exchange Web Service.
  • Marketing Intelligence
    • Fixed: Bing Ads Source component may not report detailed error message when error occurs.
  • NoSQL Components
    • Fixed: MongDB Source component worked improperly with empty array values.
    • Fixed: You may get “An error occurred writing the value for the 'xxx' column to the document” error when writing array of values in MongoDB Destination component.
  • Premium Data Flow Components
    • Fixed: Premium ADO NET Destination component using Custom Command may report “Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index” error after upgrading to v20.2.
    • Fixed: Premium ADO NET components may not detect the tables properly when using a third-party data provider.
  • Premium File Pack
    • New: We added a “Max Concurrent Connections” option in FTPS Connection Manager, which can be used to managed the maximum number of concurrent connections established to the FTP site.
    • Fixed: You may run into “Specified method is not supported” error in Premium File System Source when reading SFTP files with “Async Data Transfer” enabled in SFTP Connection Manager.
    • Fixed: Premium File Transfer Task may fail with an UnauthorizedAccessException when saving files to a local file path where the user has no read permission to the target folder.  
  • REST Services
    • Azure Tables
      • Fixed: Azure Tables REST Source and Destination components may not work properly with string type datetime values.
    • Facebook Business
      • Update: We updated the default API Version to version v9.0.
      • Update: Updated metadata in Ads Insights object to include breakdown metadata.
    • Facebook Messenger
      • Update: We updated default API Version to version v9.0.
    • Jira
      • Update: Jira REST Source component no longer fails on 404 Not Found error when reading worklogs or comments by issueId and the issue had no worklogs or comments available.
      • Fixed: Pagination in Jira REST Source component may not work properly with User, Boards and Sprints objects when working with Jira On-Premises environment.
    • Zoom
      • Fixed: Zoom REST Destination component reported error message in XML format.

Version 20.2 - November 4, 2020

This release comes with the following updates and enhancements:

  • New Components
    • Big Data
      • EDI Destination
    • Data Warehousing
      • Amazon Redshift Connection Manager
      • Amazon Redshift Source
      • Amazon Redshift Destination
      • PostgreSQL Connection Manager
      • PostgreSQL Source
      • PostgreSQL Destination
    • Marketing Intelligence
      • Bing Ads Connection Manager
      • Bing Ads Source
      • Bing Ads Destination
    • Premium Data Flow Components
      • OData Connection Manager
      • Premium OData Source
      • Premium OData Destination
      • Premium PDF Source
  • New services in REST
    • Copper
    • GoToWebinar
    • Mailgun
    • WeChat
    • Zoho
    • Zoom
  • General
    • 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: For all connection managers that involves the use of a certificate file, we now support having the file stored in Azure Blob Storage for easy access.
  • Big Data
    • Fixed: "System.ArgumentException: Value does not fall within the expected range" error when deploying package with EDI Source component.
  • Cloud Storage
    • New: We added a new "Download Chunk Size" option in the Azure Blob Storage Connection Manager.
    • Fixed: You may encounter a "Sequence contains no elements" error when uploading files to Azure Data Lake Storage Gen1 root path using Premium File Transfer Task.
    • Fixed: Azure Data Lake Storage Source component only reads x-ms prefixed columns when reading from a Azure Data Lake Storage Gen2 instance while FileContent column is enabled.
    • Fixed: Amazon S3 Source component only reads xAmz prefixed columns when reading from a Azure Data Lake Storage Gen2 instance while FileContent column is enabled .
    • Fixed: "The provided 'x-amz-content-sha256' header does not match what was computed" error when uploading multiple files to Amazon S3 in parallel.
    • Fixed: "Bucket Name was not provided" error in Premium File Transfer Task when uploading files to Amazon S3 bucket path.
    • Fixed: "Update blob operation was not valid" error in Azure Blob Storage Destination component when performing Update Blob action.
    • Fixed: "TlsVersionNotPermitted" error when downloading Azure Blob Storage files using Premium File Transfer Task.
  • Data Generation and Anonymization
    • New: Data Spawner and Data Anonymizer components now support SSIS variables as spawn/anonymization types.
    • New: Custom spawn/anonymization type in Data Spawner and Data Anonymizer components supports using SSIS variable as List of Values.
    • New: We have add a new <Null> anonymization type to the Data Anonymizer component.
    • Update: The <Ignore> spawn type has been renamed to <Null> in Data Spawner.
    • Fixed: "Source Data Affinity" option may not work correctly with the Regex anonymization type in Data Anonymizer.
  • Data Quality and Comparison
    • Fixed: "PipelineBuffer has encountered an invalid column index value" error in Duplicate Detector when the input has a column called "GroupCode".
  • Data Warehousing
    • New: We have added a new "Use Bulk Copy" option in the Snowflake Destination component, which can be used to work with large data loads leveraging Azure Blob Storage or Amazon S3 as intermediate cloud storage.
    • Fixed: Snowflake Source and Destination components might fail to list the table drop-down due to the extraordinary number of tables available in the working schema.
  • Encryption and Compression Tasks
    • New: We now support writing those errors to SSIS variables in PGP Task.
  • Google Services
    • [All] New: We added a new ThrottlingRateUnit option in all Google Connection Managers, so that you have more granular control over the throttling rate.
    • New: We added a new SPREADSHEET_DELETE_ROWS_OR_COLUMNS action to the Google Sheets Destination component. This action can be used to delete certain dimensions from the sheet.
    • [All] Update: We have lifted the maximum API Throttle Rate number, which was previously limited to 10 for all Google connection managers in prior versions.
    • [All] Fixed: "Empty path name is not legal" error in Google Connection Manager when using Service Account authentication mode.
    • Fixed: "The operation has timed out" error when you have multiple Google Sheets Connection Managers in one package and run "Test Connection" on all of them.
    • Fixed: API Throttling Rate may work not correctly in Google Analytics Connection Manager.
    • Fixed: "Object reference not set to an instance of an object" error when writing to TABLEDATA in Google BigQuery Destination component.
  • HTTP/Web Services
    • Enhancement: We have some further improved support for some special WSDL files in Web Service Components.
    • Enhancement: JSON Extract and Source components now support outputing datetime values as they are received from the service endpoint if it is configured as a string type column (such as DT_STR, or DT_WSTR).
    • Fixed: "Exception from HRESULT: 0xC0204019" error in XML Extract and Source components when importing XML files into the Document Designer.
    • Fixed: "System.Runtime.InteropServices.COMException: Exception from HRESULT: 0xC0047041" error in the JSON/XML Extract and Source components when removing nodes from a filtered tree view in the Document Designer.
    • Fixed: XML Extract and Source components does not work properly with XML elements that contain periods (.) in their name.
    • Fixed: Missing the first output row in child outputs from XML Extract or Source components when there are multiple repeated element outputs.
  • Mail Components
    • New: Email Source component now supports reading raw email content in EML and MSG file format.
    • New: Email Source component supports showing non-email folders in the File Browser dialog when working with Exchange Web Service connections.
    • New: The Test Connection function in Email Connection Manager now reports Public Folder detection results when working with Exchange Web Service connections.
  • Message Queue Components
    • Fixed: "Object reference not set to an instance of an object" error in IBM MQ Connection Manager when connecting to a remote queue manager without credentials.
  • Premium Data Flow Components
    • New: We have now added support for Pre and Post Commands in the Premium ADO.NET Source component.
    • New: When connected to an Oracle database, the Premium ADO.NET Source and Destination components now support switching to a different schema using the newly introduced Schema button.
    • New: Premium Excel Destination component supports writing column headers at a specific row.
    • New: Premium Excel Source and Destination components now come with Import/Export column functions.
    • New: Premium Excel Destination component provides two new alignment options - HorizontalAlignment and VerticalAlignment, which work for cell and header formatting.
    • New: Premium Derived Column component now includes support for the following 3 new functions:
      • IsFileLocked()
      • FileLockedBy()
      • GenerateJWT()
    • Update: (DT_DBTIMESTAMP) cast function in Premium Derived Column now follows local machine's Windows locale setting.
    • Update: Premium Excel Source component replaces line breaks with spaces when discovering Column Headers from a file.
    • Enhancement: Premium Slowly Changing Dimension component has some significant performance improvements when both of the inputs are sorted.
    • Enhancement: Premium Lookup component has some significant performance improvements when loading a large number of columns at design time.
    • Enhancement: Significant performance improvement when Create table with a large number of input columns in Premium ADO NET Destination component.
    • Fixed: "Memory is locked" error in Premium Lookup when processing DT_TEXT/DT_NTEXT/DT_IMAGE type columns while working with large data sets.
    • Fixed: NULL values from Premium Excel Source component when using Not Specified Column Names mode.
    • Fixed: "System.ArgumentNullException: Value cannot be null. Parameter name: key" error in the Premium Aggregate component when performing Group By operation, and the input column contains NULL values.
    • Fixed: Deadlock error in Premium ADO.NET Destination component when performing Bulk Update/Upsert/Delete/Full Sync action towards the same SQL table with multiple Destination components.
    • Fixed: "The given key was not present in the dictionary" error when deploying Premium Slowly Changing Dimension component and not all the outputs are attached.
    • Fixed: "Object reference not set to an instance of an object" error when performing Full Sync action with "Row by Row" write mode in Premium ADO.NET Destination component.
  • Premium File Pack
    • New: Premium File Transfer Task component now supports filtering for Send Files and Delete Files actions when working with Amazon S3, Azure Blob Storage, Azure Data Lake Storage, Azure Files, Box, Dropbox, Google Cloud Storage, OneDrive, and WebDAV connections.
    • New: Premium File System Source and Destination components support working with Amazon S3, Azure Blob Storage, Azure Data Lake Storage, Azure Files, Box, Dropbox, Google Cloud Storage, OneDrive, WebDAV connections.
    • New: SFTP Connection Manager now supports a new "Use Async Data Transfer", which can be used to transfer files asynchronously in the background, which could help improve upload performance for certain SFTP connections.
    • Enhancement: Some substantial performance improvement when using the "Remove Directory" action in the Premium File Transfer Task with an Amazon S3 connection.
    • Update: "Use Streamed Download" option in SFTP Connection Manager is renamed to "Use Streamed Data Transfer", which can be used to upload/download data from/to stream to improve transfer performance.
    • Fixed: A number of Unicode encodings were missing in Premium Flat File Destination component.
    • Fixed: "No item exists" error when emptying a local folder using Delete Files action with filter in Premium File Transfer Task.
    • Fixed: Filter Parameters grid was disabled for editing in Premium File Transfer Task if Delete Files action is used.
  • Premium Tasks
    • New: Premium File Properties Task supports working with Amazon S3, Azure Blob Storage, Azure Data Lake Storage, Azure Files, Box, Dropbox, Google Cloud Storage, OneDrive, and WebDAV connections.
  • REST
    • [All] New: We have added _HttpRequestUrl, _HttpRequestMethod, _HttpRequestHeaders, _HttpRequestBody, _HttpResponseCode, _HttpResponseCodeName, _HttpResponseHeaders output columns in the REST destination component's Default Output, which can be used for debugging purpose.
    • ADP
      • New: We added Applicant Onboard V2 API support.
    • Facebook Business
      • New: REST Facebook Business Connection now supports an APIVersion option.
      • Fixed: "Invalid appsecret_proof provided in the API argument" error in the REST Facebook Business Source and Destination components when "Use AppSecret Proof" is enabled in the Connection Manager and the token file is generated using "My Own App".
    • Jira
      • New: Jira REST Connection Manager now supports OAuth2 authentication.
      • New: REST Jira Source component now supports Issue Worklogs object.
      • New: REST Jira Destination component now supports Issue Watchers object.
      • New: Pagination support is added to Get Users from Group or Find Users By Query endpoints in REST Jira Source component.
      • Update: Field "fields.Sprint" in Issues object works with raw JSON in the REST Jira Source and Destination components.
      • Fixed: "(500) Internal Server Error" error in the REST Jira Source component when reading from Issues with worklog output enabled.
      • Fixed: "The group name can not be empty" error in the REST Jira Source component when reading from "Get Users From Group" endpoint and the "groupname" filter parameter is specified.
      • Fixed: "Error parsing time" error in the REST Jira Destination component when working with datetime values under particular conditions.
    • LinkedIn Business
      • New: LinkedIn Business REST connection now supports working with an OAuth token file, which provides the ability to automatically refresh the access_token to provide a more robust connection infrastructure.
      • Fixed: 403 Forbidden error when performing Update Ad Account action in REST LinkedIn Business Destination component.
    • Magento
      • Fixed: "Unable to cast object of type 'System.String' to type 'jey`2[System.Object,System.Object]'" error in the REST Magento Source component when working with certain special custom objects.
      • Fixed: Magento REST Source component didn't output the custom_attributes values in the child outputs.
      • Fixed: Search parameters are not properly cleared when changing source endpoints in the REST Magento Source component.
    • MYOB:
      • Fixed: "Access denied" error in the REST MYOB Connection Manager when connecting to AccountRight without MYOB credentials.
    • Microsoft Teams
      • New: We have added support for Microsoft communications API.
    • PayPal
      • New: PayPal v2 API for Invoicing, Orders, Partner Referrals, and Payments objects is supported in the REST PayPal Source and Destination components.
    • Salesforce Pardot:
      • New: Salesforce Pardot connection now supports OAuth2 authentication.
      • Fixed: "Object reference not set to an instance of an object" in REST Salesforce Pardot Source and Destination component when selecting Prospect object and the Prospect object has no custom fields.
    • ServiceNow
      • Fixed: "Object reference not set to an instance of an object" error when getting incident object's endpoints when the connection user has no full metadata permission.
    • Shopify
      • New: Shopify connection now has support for a new APIVersion option.
      • Fixed: "{query_string_paraemter} cannot be passed when page_info is present" error in the REST Shopify Source component when a filter parameter is used.
    • Slack
      • Fixed: "over_pagination_limit" error in the REST Slack Source component when reading from team.accessLogs object.
    • Smartsheet
      • Fixed: Smartsheet REST Source and Destination components may fail to list the Source/Destination Object drop-down when there are more than 100 sheets in the instance.
    • Teamwork
      • Enhancement: Updated metadata for Projects and Tasks objects in REST Teamwork Source component.
      • Fixed: "String was not recognized as a valid DateTime" error when reading due-date and start-date values from Projects object in REST Teamwork Source component.
    • Zendesk
      • Fixed: "Filename cannot be blank" error in the REST Zendesk Destination component when uploading attachment to Zendesk Support.
    • Zuora
      • New: Zuora REST Source and Destination components now support custom objects.
  • Timing & Automation Components
    • New: Time Zone Conversion component now supports working with multiple input datetime columns in the same component.
    • New: We have added a new "Output Column Type" option to the Time Zone Conversion component, which can be used to output converted datatime values into DT_DBTIMESTAMPOFFSET data type when needed.

Version 20.1 - June 9, 2020

With this release, we have added support for 20 new services (APIs), 69 components among a total of over 500 new features, updates and enhancements. Here are the following updates and enhancements:

  • New Components
    • Cloud Storage
      • Azure Files Connection Manager
      • Azure Files Source
      • Azure Files Destination
    • Timing & Automation
      • Azure Functions Connection Manager
      • Azure Functions Source
      • Azure Functions Destination
      • Azure Functions Task
      • SSH Task
    • Message Queue
      • Premium Message Queue Task
    • Conversion
      • Composition
      • Decomposition
    • Premium Data Flow
      • Premium Aggregate
    • Premium Task
      • Premium Expression Task
      • Premium File Properties Task
    • Encryption & Compression
      • Premium Hash
    • Premium File Pack
      • WebDAV Connection Manager
      • WebDAV Source
      • WebDAV Destination
  • New services in REST
    • Acumatica
    • Azure Application Insights
    • Azure Tables
    • BaseCamp
    • BigCommerce
    • eBay
    • ElasticSearch
    • EventBrite
    • Facebook Messenger
    • FreshBooks
    • Insightly
    • Magento
    • LinkedIn Business
    • Sage Business Cloud
    • Teamwork
    • Twitter Business
    • Xero
  • [General] New: We added support for working with a token file stored in Azure Blob Storage by specifying an Azure SAS URL as the token file path for any Connection Manager that supports token file.
  • [General] Enhancement: All the Transformation components and Destination components in SSIS Productivity Pack now support working with duplicate column names from upstream components as long as the columns are coming from different sources.
  • [General] Enhancement: We have made some minor improvements in our retry implementation on intermittent errors.
  • [General] 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.
  • [General] Update: We have adopted a new versioning strategy in this release. Going forward, 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. All our current releases should have the same version number of v20.1.0 with a revision number between 1561 and 1601.
  • [General] Update: We have introduced a new branding panel in our UI forms to distinguish our components from those out-of-box ones.
  • [General] Update: We updated .NET framework requirement to v4.6.1 for SSIS 2012 and above.
  • [General] Update: Our license manager program now requires .NET Framework 4.0 or above.
  • Premium Data Flow Components
    • Premium ADO.NET
      • New: Premium ADO.NET Source component now supports using SSIS variables as table names when Custom Command option is used.
      • New: Premium ADO.NET Destination component now supports returning additional output columns.
      • New: Premium ADO.NET Destination component now supports writing to MySQL tables in Batch Insert mode and Bulk Insert mode when using MySQL Data Provider.
      • New: We added a "Write Mode" option in Premium ADO.NET Destination component, available options include: Row by Row, Batch and Bulk.
      • Enhancement: Premium ADO.NET components now automatically detect the supported Transaction Isolation Level for the specified connection manager.
      • Update: We removed the "Use Bulk" option in Premium ADO.NET Destination component.
      • Fixed: Premium ADO.NET Source component may report an "Only MySqlParameter objects may be stored" error when clicking the Preview button with a MySQL Data Provider connection in the case that an SSIS variable is used in the command.
      • Fixed: You may get an error "The target table 'target' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause" when performing Bulk Update/Upsert/Delete/Full Sync actions against a SQL table which has triggers defined.
      • Fixed: You may run into an error "Cannot insert duplicate key in object '{TableName}'" when performing non-bulk Upsert action against a SQL client connection manager.
      • Fixed: You may get a "CLI0129E An attempt to allocate a handle failed because there are no more handles to allocate" error in Premium ADO.NET Destination after writing thousands of records to an IBM DB2 table.
      • Fixed: Premium ADO.NET Destination may not report the detailed error message on each failed record when performing non-bulk Insert action and the Error Handling is set to "Redirect rows to error output".
    • Premium Excel
      • New: Premium Excel Source/Destination components support working with worksheet index now.
      • New: We added an "Ignore Cast Exception" option in Premium Excel Source columns, which can be used to prevent the component from failing should an InvalidCastException occur.
      • Update: We removed the "Specify End Row" option from Premium Excel Destination component when write mode is set to "Write to specific rows"
      • Fixed: Premium Excel components may not detect the format and background colors properly when Column Name option is set to Start Row.
      • Fixed: You may run into a "System.ArgumentException: An item with the same key has already been added" error when running multiple Premium Excel Source components to read from the same file simultaneously.
    • Premium Derived Column
      • New: We added the following functions to Premium Derived Column component:
        • Char()
        • Try()
        • FormUrlEncodedToJson()
        • GzipCompress()
        • GzipDecompress()
        • DeflateCompress()
        • DeflateDecompress(),
      • New: HtmlEncode() function now supports representing by entity name.
      • Fixed: Expression NULL(DT_NTEXT) had an output data type of DT_WSTR(255).
      • Fixed: SubString() function was using test value for validation in Premium Derived Column.
      • Fixed: WriteValueToVaraible() may not work properly when Premium Derived Column is used in a Foreach Loop container.
      • Fixed: You may get an "Unable cast to type 'System.IConvertible'" error in Premium Derived Column when casting bytes to a numeric data type.
    • Premium Slowly Changing Dimension
      • New: We added support for using GUID column as surrogate key in Premium Slowly Changing Dimension component.
      • Fixed: "Use Bulk" option was disabled when writing to Oracle ODP.NET Unmanaged connection in Premium Slowly Changing Dimension component.
    • Premium Conversion
      • New: We added an "Ignore Cast Exception" option in Premium Conversion columns, which can be used to prevent the component from failing should an InvalidCastException occur.
      • Fixed: The Premium Conversion component may still report a NullReferenceException when Error Handling is set to "Redirect rows to error output".
  • Cloud Storage
    • Amazon S3
      • New: We added support for Set ACL action in Amazon S3 Destination component.
      • New: We added a new "Ignore Certificate Errors" option in Amazon S3 Connection Manager, which can be used to ignore any SSL certificate errors.
      • Fixed: You may get 'System.OutOfMemoryException' error while uploading large files (>1GB) to Amazon S3 using multi-threaded file uploading.
    • Azure Blob Storage
      • New: Azure Blob Storage Destination component now reports HTTP error status code in the ErrorCode column in the Error Output with a prefix of "800000" such as "800000409" to represent a 409 error..
      • Enhancement: Azure Blob Storage Source component has some significant performance improvement when file_content and the x-ms prefixed columns are not selected.
      • Fixed: You may get 'System.OutOfMemoryException' error while uploading large files (>1GB) to Azure Blob Storage.
    • Box
      • New: We added a "Max Depth" option in Box Source component, which can be used to specify how many levels of folders to read when reading in the recursive mode.
      • New: We added an "API Throttle Rate" option in Box Connection Manager.
      • New: We added support of using My Own App in Box Connection Manager.
      • Update: We have switched to use token files instead of relying on Windows registry to store and manage authentication tokens for better security and easier deployment.
      • Fixed: You may run into 404 Not Found error when updating tags of a folder record in Box Destination component.
      • Fixed: Downloading a specific file from Box using Premium File Transfer Task may not work properly.
      • Fixed: You may get a NullReferenceException error when downloading Box files recursively in Premium File Transfer Task.
    • Dropbox
      • New: We added support of using My Own App in Dropbox Connection Manager.
      • Fixed: You may get a "The process cannot access the file because it is being used by another process" error in Premium File Transfer Task when uploading files to Dropbox.
    • Google Cloud Storage
      • Fixed: Google Cloud Storage Destination component may validate for required "ObjectResource" field but the field is not available in the destination metadata.
      • Fixed: You may receive a 'System.OutOfMemoryException' error while uploading large files (>1GB) to Google Cloud Storage.
    • OneDrive
      • New: We added a "Tenant Id" property in OneDrive Token Generator, which can be used to authenticate towards a specific Azure tenant.
  • Google Services
    • [All] Update: We have switched to use token files instead of relying on Windows registry to store and manage authentication tokens for better security and easier deployment.
    • [All] Fix: You may find a warning message in SSIS Execution Result that the Google token is generated using the app provided by KingswaySoft when the Google token was actually generated using My Own App.
    • [All] Fixed: You may receive a "System.NullReferenceException: Object reference not set to an instance of an object." error in Google Connection Manager when testing connection using Service Account authentication mode, this only happens to some unique system situations.
    • Google Analytics
      • New: Google Analytics Source component now supports outputting sampling information (sampleSize and sampleSpace).
      • New: We added support of specifying custom metrics and custom dimensions in Google Analytics Source component.
      • Enhancement: Improved handling of user permission errors when authenticating using Service Account in Google Analytics Connection Manager.
      • Fixed: You may run into NULLReference exceptions when testing connection in Google Analytics Connection Manager with a service account while a proxy is in use.
    • Google Ads
      • New: We added support for discovering available CustomerIds for the authenticated user in Google Ads Connection Manager.
      • Enhancement: Improved UI performance with select/unselect all output columns in Google Ads Source component.
      • Fixed: Google Ads Source component may crash when selecting LANDING_PAGE_REPORT report type.
    • Google BigQuery
      • Enhancement: We improved the error handling when authentication failed in Google BigQuery Connection Manager.
      • Enhancement: Improved UI performance with select/unselect all output columns in Google BigQuery Source/Destination component.
      • Fixed: Google BigQuery Source/Destination may fail listing all the datasets in a project when the project contains has more than 50 datasets.
    • Google Sheets
      • Update: We removed "Specify End Row" option from Google Sheets Destination component.
      • Fixed: You may run into a "Cannot deserialize the current JSON object' error" in Google Sheets Source/Destination component when the specified worksheet contains a filter view.
      • Fixed: Google Sheets Source component may fail with the "Input string was not in a correct format" error when reading an empty cell while the output column is in a numeric data type.
      • Fixed: You may receive an error "System.ArgumentException: Value does not fall within the expected range" in Google Sheets Destination when the default output is attached.
      • Fixed: Google Sheets Destination component may not work properly with NULL value with those non-string type fields.
  • HTTP/Web Services
    • New: Added a new AWS Signature authentication mode in HTTP Connection Manager, which supports Amazon Signature Version 4 and Signature Version 2.
    • New: We added support of Kerboros authentication mode in HTTP Connection Manager.
    • New: We added JWT authentication mode support in HTTP Connection Manager.
    • New: HTTP Connection Manager now supports Custom Token authentication by making a web request to retrieve an authorization token using a CURL command from a file, then extract the token from the web service response.
    • New: JSON/XML Source component now supports using variable as the source.
    • New: We added a new "Key Value Pivot" Output Type in JSON/XML Extract/Source component, which can be used to work with key/value pairs values.
    • New: JSON/XML Source component now supports @[ResponseStatusCode] token for expression evaluation.
    • New: We added an "Allow Data Truncation" option in JSON/XML Source component.
    • New: We added support of sending JSON formatted token request in OAuth Token Generator when the Content-Type request header is set to "application/json".
    • Update: HTTP Connection Manager now uses certificate thumbprint to specify the SSL certificate instead of using the certificate subject.
    • Update: We have renamed Credential authentication mode in HTTP Connection Manager to "Credential (Basic, Digest, NTLM)".
    • Update: HTTPRequestURL default output column in JSON/XML Destination component now has a default length of 4000.
    • Update: RequestURL output column in JSON/XML Source component now has a default length of 4000.
    • Update: The maximum allowed Max Identical value in JSON/XML Source component is now set to 500.
    • Fixed: You may find an error "The PrimeOutput method returned success, but did not report an end of the rowset" in SSIS Execution Results when a child output is enabled but not attached in JSON/XML Source.
    • Fixed: JSON/XML Source component may fail on 403 HTTP status code even though 403 has not been specified as an error code in HTTP Connection Manager.
    • Fixed: You may run into "Irony.Interpreter.ScriptException" error in JSON/XML Source component when running multiple JSON/XML source components
      in parallel and the same project parameter is used in each source component.
    • Fixed: You may get NULL value in _HttpRequestIndex column in the HTTP Request Output in JSON/XML Source component.
    • Fixed: JSON/XML Destination component may report duplicate column validation error on [ErrorCode] column when the input contains a column named "ErrorCode".
    • Fixed: The default output of JSON/XML Destination component may lost all output columns after metadata changes from upstream components.
    • Fixed: In some specific situations, you may get a NullReferenceException in JSON Source component after processing hundreds of records if the component is used in a Foreach Loop Container.
    • Fixed: JSON/XML Source component may fail reading the local file if the file is encoded in UCS-2 LE BOM.
    • Fixed: Encoded value "%20" in URL may get sent as "+" when testing connection in HTTP Connection Manager.
    • Fixed: HTTP Requester component may report OutOfMemory error when downloading a large file into the output DT_IMAGE field.
  • Mail Components
    • New: We added a "Post Retrieve Action" option in Email Source component, which can be used to delete or mark received email as deleted on the email server.
    • New: Email Source component now supports outputting the FolderPath of the email record.
    • New: We added support of getting email by MessageId in Email Source component for IMAP/Exchange Web Service connections.
    • Enhancement: Significantly performance improvement when working with Exchange Web Services protocol in Email Source if the Attachment output is not attached.
    • Enhancement: Some UI drag & drop improvement in WYSIWYG designer in SMTP Task/Destination component.
    • Fixed: SMTP Task/Destination component may not work properly when an image src path uses SSIS variables in the HTML email body.
  • NoSQL Components
    • New: CosmosDB Source/Destination component now supports working with raw document text as a column.
    • Enhancement: CosmosDB Destination component now validates the node type of the root node in order to prevent the "Object serialized to Array. JObject instance expected" error when the root node is accidentally set to an array.
    • Update: Cassandra/MongoDB Connection Manager now uses certificate thumbprint to specify the SSL certificate instead of using the certificate subject.
    • Update: We have renamed "Convert ObjectId to String" option in MongoDB Source component to "Convert Mongo types to strings" to better support MongoDB datetime values when "Output as JSON" option is enabled.
    • Fixed: CosmosDB Source component UI always sets the same variable for the Input Variable and Output Variable when working with Document Change Feeds.
    • Fixed: You may get error "There is no Database named 'xxx'." when running multiple CosmosDB Source components in parallel.
    • Fixed: MongDB Destination component may write input datetime values in local system timezone while the component Input Timezone has actually been set to UTC.
  • Premium File Pack
    • New: Send Files and Delete Files actions in Premium File Transfer Task component now support filtering when working with Local/SFTP/FTPS connection.
    • New: We added a "Use Legacy Group Exchange" option in SFTP Connection Manager, which can be used to specify whether to use legacy form of Diffie-Hellman group exchange.
    • New: We added support of using wildcard characters within SFTP and local files in Premium File System Source component.
    • New: Premium File System Source component now supports filter parameters.
    • Update: FTPS Connection Manager now uses certificate thumbprint to specify the SSL certificate instead of using the certificate subject.
    • Fixed: You may get a "The connection was closed by the server" error when downloading files from SFTP server in recursive mode.
    • Fixed: Premium File System Source component may report a System.InvalidCastException error when outputting a string value to a DT_NTEXT field.
  • REST
    • [All] New: You can now use SSIS variables in the Filter Parameters grid in REST Source component.
    • [All] New: We added support for outputting raw response bodies in REST Destination component.
    • [All] Enhancement: Improved OAuth Configuration & Sign-In UI for all any REST connections that use a token file.
    • [All] Fixed: You may find an error "The PrimeOutput method on "REST Source" returned success, but did not report an end of the rowset" in SSIS Execution Results when a child output is enabled but not attached in the REST Source component.
    • Act-On
      • Fixed: Sending null values to Act-On to overwrite existing values may not work properly when performing Update action in Act-On REST Destination component.
    • ADP
      • New: We added support for "Codelists - Emp. Profile and Ben. Grps" endpoint in ADP REST Source component.
      • Update: The maximum batch size in ADP REST Source component is set to 100.
    • Facebook Business
      • New: We updated the API support to version v6.0.
      • New: Facebook Business REST Source/Destination component now supports using App Access Token.
      • Enhancement: Updated metadata.
    • Jira
      • Fixed: You may run into a BadGateway error in Jira REST Connection Manager when clicking the Generate Token button and the server URL does not end with "/".
      • Fixed: Jira REST Source component may fail with "System.ArgumentNullException: Value cannot be null. Parameter name: value" error when reading from Boards object while working with a Jira on-premises environment.
    • MailChimp
      • Enhancement: Better MailChimp metadata detection for the array of objects.
      • Fixed: You may run into error "The resource submitted could not be validated" in MailChimp REST Destination component when sending an empty string to a raw field with a batch size greater than 1.
    • Microsoft Teams
      • Enhancement: Updated metadata for the Chat Message object.
      • Update: We have updated some Microsoft Teams preview objects to use the Microsoft Graph REST v1.0 API.
    • MYOB
      • Enhancement: Updated metadata to support the Multi-location feature in AccountRight.
      • Fixed: Sending null values to MYOB to overwrite existing values may not work properly with Update action in MYOB REST Destination component.
    • Salesforce Pardot
      • New: We now support working with Salesforce Pardot custom fields that have Record and Display Multiple Response option enabled.
      • Fixed: Salesforce Pardot REST components may fail with an "Invalid API key or user key" error after the package has been running for over 30 minutes .
      • Fixed: Pagination in Salesforce Pardot REST Source component may not work properly with Campaign, List and Email Click objects.
      • Fixed: Salesforce Pardot REST Destination component might ignore the batch size setting when using Batch action with Prospect object.
    • ServiceNow
      • New: ServiceNow REST Connection Manager now supports specifying the service Base URL.
      • Update: We removed Instance Type from ServiceNow REST Connection Manager.
    • Shopify
      • New: We added support for cursor-based pagination in Shopify REST Source component to support version 2019-07 of the API and above.
      • New: We added support of using My Own App in Shopify REST Connection Manager for the Public App (OAuth) authentication mode.
      • Enhancement: Updated metadata.
    • Smartsheet
      • New: We added support of working with Smartsheet Gov Account.
      • New: We added a new Sheet object in Smartsheet Source/Destination component to work with existing sheets in a tabular format by discovering the metadata from the sheet.
      • New: We added a new Report object in Smartsheet Source component to read from existing reports in a tabular format by discovering the metadata from the report.
    • SurveyMonkey
      • New: SurveyMonkey REST Source component now supports outputting the survey response in a flatten format through the new "Get Survey Response Answers in Bulk" endpoint.
      • Fixed: SurveyMonkey Source component may not return any records in SSIS pipeline when reading Webhook object even there were records returned.
    • WordPress
      • New: We added support of working with WordPress.com hosting.
      • Fixed: WordPress REST Source component may crash when there is a problem with the connection.
      • Fixed: WordPress REST Destination component might ignore the batch size setting when working with WooCommerce objects.
    • Wunderlist
      • Deprecation: We have removed Wunderlist support.
    • Zendesk
      • New: We added support for Zendesk Help Center API.
      • New: We added Zendesk incremental export API support, which can be used to retrieve delta changes in Zendesk Support since a given datetime.
      • New: Zendesk REST Source component now supports retrieving Ticket Comments along with the associated Attachments when working with Tickets object.
      • New: Zendesk REST Source component now supports retrieving User Identities when working with Users object.
      • New: We added a sinceDateTime filter parameter to Ticket Audits object in Zendesk REST Source component, which can be used to retrieve ticket audits records relative to a given date.
      • Enhancement: Improved handling of retry on HTTP 429 errors.
  • Data Quality and Comparison
    • Fixed: Diff Detector/Duplicate Detector component may report duplicate column validation error on [ErrorCode] column when the input contains a column named "ErrorCode".
  • Data Warehousing
    • New: Snowflake Source/Destination component now outputs the Snowflake queryId in the error message.
    • Update: We removed the Region option from Snowflake Connection Manager, user needs to specify the full account name in the Account property. Existing Snowflake Connection Manager should upgrade smoothly.
  • Encryption and Compression Tasks
    • New: We added a "Compression Format" option in Compression Task component, which allows you to compress/decompress the file in Zip, Gzip and Deflate formats.
    • New: Compression Task now supports wildcard when performing Decompress Zip file action.
    • Fixed: PGP Task may work improperly when performing Decrypt action and the key ring contains multiple private keys.
  • Message Queue Components
    • New: We added a "Use MQCSP Authentication" option in IBM MQ Connection Manager.
    • Update: AMQP/RabbitMQ Connection Manager now uses certificate thumbprint to specify the SSL certificate instead of using the certificate subject.
    • Fixed: RabbitMQ Destination component may not close the connection properly during runtime when it is executed through SQL Server agent job.
  • Template Merge Components
    • Enhancement: Some UI drag drop improvement in WYSIWYG designer in HTML Merge component.
    • Fixed: HTML Merge component may work improperly when an image src path uses SSIS variables in.
    • Fixed: HTML Merge component may report duplicate column validation error on [ErrorCode] column when the input contains a column named "ErrorCode".
    • Fixed:HTML Merge component may work improperly when the input column or variable value contains HTML.
  • EDI Source Component
    • New: We added Error Handling support in EDI Source component to report Segment/Loop parsing errors.
    • Fixed: EDI Source component may output null values in the _ParentKeyFiled column when the parent output is not attached.
    • Fixed: You may receive a "System.NullReferenceException: Object reference not set to an instance of an object." error in EDI Source when working with some specific EDI files with "Flatten Loop Segments" option enabled.
    • Fixed: Importing an EDI file with repeated segments at the root level in EDI Source component may fail with a "There are multiple column nodes with the Data Name of 'xxx' underneath of the 'Root' output node" error.

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