SSIS Integration Toolkit

Version 26.2 - June 30, 2026

This release comes with the following updates and enhancements:

• General:
  
  • New: We have some improved licensing support for Azure and AWS EC2 virtual machines. License activations are now bound to the cloud instance itself. This makes license installations more resilient, allowing them to persist through operating system reinstalls, instance resets, and other system-level changes.
  • Enhancement: We have upgraded Salesforce, Dynamics CRM, and Bing Ads web services to .NET Framework 4.7.2.
• New services and components in the REST framework:
  • Odoo
  • Enthuse
  • SendPulse
  • Temu
• Major Enterprise Applications (Previously individually shipped integration toolkits):
  
  • Dynamics 365 (Formerly SSIS Integration Toolkit for Microsoft Dynamics 365)
    • Dynamics AX/F&O
      • Fixed: Dynamics AX/F&O Connection Manager working with OData API using the OAuth Authorization Code authentication could result in a sign-in error: "AADSTS900144: The request body must contain the following parameter: 'scope'".
    • Dynamics CRM/Dataverse
      • New: We added support for EntityCollection parameters when working with the ExecuteWorkflowAction action in a Dynamics CRM/Dataverse Destination component. Previously, utilizing an EntityCollection parameter would trigger an error such as "System.NotSupportedException: EntityCollection input argument ('To') is not supported.
      • New: We added support for handling OAuth while using PingFederate. When the authorization URL ends with /authorization.oauth2, and the token URL ends with /token.oauth2, token requests will now be sent to the configured token URL instead of the /OAuth2/v2.0/token endpoint.
      • Enhancement: We have some further performance improvements when using the Audit Logs source type to read Dynamics/Dataverse audit records in a Dataverse/CRM source component.
      • Enhancement: The option Suppress General Service Exception in the Dynamics CRM/Dataverse source component now has some improved handling to suppress audit log related 404 and other general server-side errors.
        
      • Fixed: The default column length for LogicalName in the Dynamics Source component's FieldMetadata output has been increased from nvarchar(64) to nvarchar(128) to accommodate Microsoft's longer field names.
      • Fixed: Fixed an issue in the Dynamics CRM/Dataverse Source component where the Primary Output unexpectedly returned null values. This behavior only occurred in version 26.1 when using the Audit Logs source type with a FetchXML query targeted at a business entity.
    • Dynamics NAV
      • New: When using the Dynamics NAV source or the Premium Service Lookup component with Dynamics NAV connection, we have added the ability to indent or dedent conditions to achieve nested query conditions. 
      • New: We added the ability to download attachment/file content for those attachment file fields transparently if they are selected in the Dynamics NAV source component. 
      • Update: We have added support for V28 Business Central applications in the Dynamics NAV connection manager.
      • Fixed: Writing document/file attachments to Business Central in Dynamics NAV destination component may result in a "Read called with an open stream or textreader. Please close any open streams or text readers before calling Read" error. 
  • HubSpot (Formerly SSIS Integration Toolkit for HubSpot)
    • New: We have added support for new endpoints such as "Update a Property", "Fetch List Memberships", and "Update List Memberships".
    • Fixed: The HubSpot Destination component may not return the HubSpotRecordID in the Default Output when using the “Upsert” action.
    • Fixed: Reading from objects with the listId parameter specified while having a DT_DATE column in the component can cause a parsing exception in the HubSpot Source component.
  • SharePoint (Formerly SSIS Integration Toolkit for Microsoft SharePoint)
    • Enhancement: We have removed the use of the legacy SchemaXml schema in the SharePoint Source and Destination components. This change resolves an issue that could cause a 500 Internal Server Error with a BDC-related exception in certain scenarios.
    • Fixed: SharePoint connections using REST service endpoint might have trouble working with long file or folder paths or when they contain some special characters. 
    • Fixed: The SharePoint source component may not return any values for those multi-person fields.
    • Fixed: The SharePoint Destination component may raise the error "Value does not fall within the expected range" when creating files in a picture library.
    • Fixed: ContentType input value might be ignored in the SharePoint destination component while using the Update action.
    • Fixed: SharePoint Connection Manager UI may not load and display the saved custom Authorization Server URL upon re-opening.
  • NetSuite (Formerly SSIS Integration Toolkit for NetSuite)
    • Update: When using a SuiteQL query in the NetSuite Source component, changes made to the query no longer always trigger a full metadata refresh of the component, which could break downstream pipeline components. 
    • Fixed: When using the REST endpoint in the NetSuite Source component, field data types may not be correctly detected in SuiteQL queries that use table aliases.
    • Fixed: Passing through columns of "Blob" type (NTEXT or IMAGE) for the Default Outputs does not work properly in the NetSuite Destination component.
      
    • Fixed: NetSuite Source component in the SuiteQL mode may revert changes made to data types after reopening the component.
  • Salesforce (Formerly SSIS Integration Toolkit for Salesforce)
    • Update: We have discontinued support for the KingswaySoft App in OAuth authentication mode within the Salesforce connection manager. This change aligns with new API limitations that Salesforce has imposed on Connected Apps and External Client Apps.
    • Fixed: Salesforce Destination component now supports changing error output's output column length or metadata type so that they can accommodate longer error messages returned by Salesforce. 
    • Fixed: Salesforce destination using Bulk API could fail with an error, even when the batch writing has been successful.
    • Fixed: When there is a runtime error, Salesforce destination component may not correctly report the error message, but instead the component fails even the component's Error Handling option is set to "Redirect rows to error output."
    • Fixed: When using OAuth authentication with an External Client App in the Salesforce Connection Manager, the component may not be using the correct authorization URL when the Sandbox environment is selected.
  • SAP (Formerly SSIS Integration Toolkit for SAP)
    • Fixed: SAP components may report the "The installed license is invalid" error even when an Ultimate license has been installed.
  • Team Foundation Server (Formerly SSIS Integration Toolkit for Team Foundation Server)
    • Fixed: TFS Connection Manager might raise a "Method not found" error after upgrading to v26.1 from an earlier version when using the SOAP endpoint.
    • Fixed: TFS source component may also raise "Could not load file or assembly" when using the REST endpoint.
• Big Data
  • Update: We have upgraded Parquet library to version 5.6.1 used by the Premium Data File Source and Destination components. This update resolves issues that could result in System.InvalidOperationException errors during file imports in the Premium Data File Source component, as well as System.NullReferenceException errors when writing to map-type fields in the Premium Data File Destination component.
  • Fixed: When reading an Avro file using the Premium Data File component, you may encounter a "Could not load file or assembly" error. 
  • Fixed: Improved error reporting while reading a Parquet file in the Premium Data File Source component. When an "Index was outside the bounds of the array" error occurs due to a library limitation, the error message now indicates the affected column.
• Marketing Intelligence
  • Fixed: When working with Microsoft Advertising/Bing Ads Connection Manager, Tenant ID is not included in the authorization API call when using the OAuth authentication.
  • Fixed: Bing Ads Source component might report a "Deserialization error" during runtime after receiving a response from the server.
• Data Warehousing
  • Fixed: While using the Snowflake components, the Command Timeout setting may not be fully respected when the value is higher than 300.
    
  • Fixed: In the PostgreSQL Command Task component, parameters may not be fully visible when more than 50 parameters were configured. A scrollbar has now been added to the Parameters page, allowing all parameters to be viewed and accessed. 
  • Fixed: The Snowflake Destination component may create permanent tables instead of transient tables when the temporary table option is selected in write actions.
• Encryption and Compression Task
  • New: We have added support for a new "Symmetric Key Algorithm" option in the PGP Task for the Encrypt action, whereas previously, file encryption was limited to the TripleDES algorithm.
• HTTP / Web Services
  • Enhancement: We have added support for the Value Path Type and Path to Value properties in the HTTP Response output. These properties allow you to specify a response header name and return its corresponding value directly.
  • Fixed: GraphQL Source component may raise an error "Error trying to resolve field 'fields'" during metadata discovery for objects without fields.
  • Fixed: Using Partial Cache in Premium Service Lookup component with a GraphQL Connection Manager, when there multiple input rows, only the first match is returned correctly, while subsequent matched rows may contain duplicate values from the first match.
  • Fixed: When using a GraphQL Connection Manager in the Premium Service Lookup, values provided for the Arguments option may not be saved properly.
  • Fixed: GraphQL Source and Destination components did not properly fail when the API returned an error in the response body with an HTTP 200 OK status code.
• JSON & XML Processing
  • Fixed: JSON Source component may raise an "Access to the path is denied" error when loading a file from a folder with read-only permissions.
• Message Queue
  • Enhancement: We have updated the libcurl.dll Kafka library to version 8.20.x to pass the security audit. 
  • Fixed: When creating a large volume of records, such as 10,000 records, the Azure Service Bus Destination may fail to create all records successfully.
  • Update: We have updated the libssl-3.dll library in Kafka and OpenSSL for the vulnerable assembly issue.
• NoSQL Components
  • New: We have added a new "SASL mechanism" option to MongoDB Connection Manager, which can be set to an explicit option to be used instead of negotiating one with the server. Previously, MongoDB connection manager may report an error such as "Unable to authenticate using SASL protocol mechanism SCRAM-SHA-1" when the negotiation fails. 
  • New: We have added support for Couchbase Analytics Service API in the Couchbase source component.
  • New: We have added a new "Load Key Matching Pattern" option to Redis Source component now for improved metadata discovery during runtime. 
  • Fixed: The Firestore Destination may report an error indicating that the required fields are not mapped, even when the fields are correctly mapped.
• Premium File Pack
  • New: We have added a HeaderQualifier property for columns in the Premium Flat File destination component, which allows you to choose whether to apply a qualifier to headers depending on whether it is set to Auto or Yes.
  • New: The SFTP Connection Manager may raise the error "The connection was closed by the server" after upgrading to version 26.1. To address this issue and improve compatibility with different SFTP servers, we have added a few new options to the connection manager, including UseStrictKeyExchange, MaximumPacketSize, and MinimumDiffieHellmanKeySize properties. If you are encountering "The connection was closed by the server" error as a result of upgrading to v26.1 or above, you may need to set the UseStrictKeyExchange option to false to resolve this issue.
• Premium Data Flow Components
  • Fixed: The Premium Excel may not fail properly when an error has occurred while reading Excel files, even the component's error handling option has been set to "Fail on error".
  • Fixed: The Premium Excel Destination component may not write a Datetime value with the specified format string, but instead writes the Excel serial value. This is a v26.1 specific issue. 
  • Fixed: When reading from a PDF file, the PDF source component might report a "Could not load file or assembly" error after upgrading to v26.1 release. 
  • Fixed: Using Azure Active Directory Authentication Mode in Premium SQL Server Connection Manager may raise a "Method not found" error after upgrading to v26.1 release.
• Mail Components
  • Update: According to the Microsoft documentation, EWS will be fully deprecated in October 2026. To support this transition, we have added a new authentication mode, Exchange Online (Microsoft Graph), to the Email Connection Manager.
• REST Components
  • New: We have added PKCE OAuth authorization code flow support when generating an OAuth token in the Slack REST Connection Manager.
  • New: We have added support for OAuth Authorization Code Authentication in the BambooHR REST Connection Manager.
  • Enhancement: We have updated various endpoints to support cursor-based pagination in the Zendesk REST Source component. 
  • Enhancement: We have updated the OAuth Authentication request in the Facebook Messenger REST Connection Manager to stop sending the fields=access_token parameter in the API request. 
  • Enhancement: Previously, the Slack REST source and destination components only accepted datetime values in Unix timestamp format. We have now added internal datetime conversion support, allowing datetime values to be provided in various formats without requiring manual conversion to Unix timestamps.
  • Update: We have updated the LinkedIn objects: AdAccounts, Campaign Groups, Campaigns, and Creative API to adopt cursor-based pagination.
  • Update: We have updated the LinkedIn objects: AdAccounts, Campaign Groups, Campaigns, and Creative API to include the advertiser account ID in the URL path.
  • Update: We have added support for Batch writing in Microsoft Planner.
  • Update: We have added support for user scopes in both the Long-lived Access Token and OAuth authentication modes in the Slack REST Connection Manager. Additionally, for the Long-lived Access Token authentication mode, we have introduced an option that allows you to explicitly provide a user API token.
  • Update: We have added support for Token type (Auto, User Token, Bot Token) in Slack REST Source and Destination components.
  • Update: We have added support for additional Emfluence endpoints, including the SMS Messages and Social Messages objects.
  • Update: We have updated metadata in SurveyMonkey REST components.
  • Update: We have updated metadata for the Product object in the PayPal REST components.
  • Update: We have updated metadata in the Microsoft To Do REST components.
  • Update: We have added support for OAuth authentication mode in Emarsys REST Connection Manager.
  • Update: We have added support for OAuth authentication mode in Copper REST Connection Manager.
  • Fixed: Miscellaneous metadata-related fixes in some endpoints in the ADP components.
  • Fixed: The field dateSuppressed has been added to contacts>getGroups endpoint in the Emfluence source component.
  • Fixed: The activities query parameter in contacts/activities is incorrectly sent as a string instead of an array when using the Emfluence REST source component.
  • Fixed: A 400 Bad Request API response could occur when reading objects in the ADP source component due to the use of the "$count" query parameter, which was resolved by removing the $ character.
  • Fixed: We have updated the metadata for the Contacts/Activities endpoint in the Emfluence REST source component to include missing fields.
  • Fixed: We have added support for the Region in the Typeform REST Connection Manager to support different regions.
  • Fixed: Issue in the Zendesk REST Destination component where the required id parameter was not included in the upsert action for Support > Organizations.
  • Update: We have added support for the new OAuth authentication flow required by newly created API keys in MYOB AccountRight. A new Cloud V2 option has been introduced in the MYOB Connection Manager to enable authentication with the updated MYOB platform.

Version 26.1 - March 30, 2026

This release comes with the following updates and enhancements:

• General
  • Major Updates: After 14 years of serving the data integration community, we are proud to announce the first unified product release of our SSIS product family. We have consolidated 15 individual integration toolkits and our flagship SSIS Productivity Pack into one comprehensive solution: the SSIS Integration Toolkit (formerly known as the SSIS Integration Toolkit - Ultimate Edition). This change simplifies installation and management by providing our entire suite of SSIS connectivity and productivity solutions in a single installation package. Consequently, standalone toolkits and SSIS Productivity Pack are no longer offered for new purchases or separate downloads. Existing legacy standalone licenses continue to work for the previously licensed components and remain eligible for renewal at the current market rate at the time of the purchase. We highly encourage all users to transition to the new unified SSIS Integration Toolkit for a streamlined and unified licensing and install management experience.
  • Update: We have updated our licensing policy so that a commercial license will be required when executing packages from within Visual Studio if running a server operating system.
  • Update: We have updated our licensing system so that a Single Server and IR license can be used interchangeably between on-premises servers and IR instances. An update to the latest version (v26.1+) is required in order for this to work.
  • Update: We have a new installation experience due to the product consolidation above. The new installer will uninstall all previous individually installed SSIS toolkits and SSIS Productivity Pack as needed. This is to ensure that you are always running the same release wave binaries for all components, particularly those shared features and components, such as Premium File Pack, Premium Service Lookup, among a few others.
  • Enhancement: We have enhanced the component refresh features across the board for all our SSIS components so that they provide a new Export button upon the completion of the refresh, which allows you to export the results of the metadata refresh operations. In addition, the refresh report window contains newly added details, such as the data type before and after refreshes when there are changes.
  • Enhancement: We have added support for ECDsa signature algorithm: ES256/384/512 in OAuth Certificate Credentials.
  • Update: The OAuth Certificate authentication option in an HTTP-based Connection Manager no longer requires the certificate to be exportable.
  • Update: The OAuth Certificate authentication option in an HTTP-based Connection Manager uses PS256 as the default signature algorithm.
  • Update: We have updated the entity name and field name metadata to have a new length of 128 instead of 64 previously. This helps eliminate an error in the Dynamics CRM/Dataverse source component when you have an entity or field that has a name that is longer than 64.
  • Fixed: When working with a string/ntext column that contains a full datetime string, the DCRM/Dataverse source component might fail with an error.
  • Fixed: The Generate documentation in the General page of source components may not save data when using Visual Studio 2026.
• New services and components in the REST framework
  
  • Zoho Inventory
  • Splunk
  • EmailOctopus
  • Outreach
• Major Enterprise Applications (Previously individually shipped integration toolkits)
  • Dynamics 365 (Formerly SSIS Integration Toolkit for Microsoft Dynamics 365)
    • General
      • New: We have added a new "Remember My Choice" option in the discretionary metadata refresh windows for all Dynamics 365 components.
    • Dynamics AX/F&O
      • Fixed: The Dynamics AX source and destination components may not show the full list of recurring projects when the number of recurring projects is high in the system.
    • Dynamics CRM/Dataverse
      • New: We have added support for Azure Arc-based managed identity authentication.
      • New: We have added support for using the Power Platform API for online organization discovery, which replaces the soon-to-be-deprecated global discovery service (GDS).
      • New: We have added a new "Return Unmasked Sensitive Data" feature in the Dataverse/CRM source component when working with a SOAP 2011 service endpoint.
      • New: We have added a new "Include Certificate Chain in Assertion" option in the Dataverse/Dynamics CRM Connection Manager, which provides SNI-based inspection support when needed.
      • New: We have added support for two new properties when working with the FieldMetadata source type in a Dataverse/Dynamics CRM source component, namely MaxLength and Precision.
      • Enhancement: There are some significant reading performance improvements when using the Audit Logs source type to read Dynamics/Dataverse audit records in a Dataverse/CRM source component.
      • Enhancement: Should a Dataverse/Dynamics CRM field have been modified to a shorter field/column length after initial customization, the Dynamics CRM/Dataverse source component may report a column length that would result in a buffer not fit or overflow error during runtime. We have improved such metadata handling to avoid this particular error situation in the source component.
      • Fixed: Multi-threaded writing may not fully accurately respect the number of concurrent threads specified in the Dataverse/Dynamics CRM destination and command task components.
      • Fixed: The null values may not be properly returned when working with the partial and no cache mode if multiple matching results are returned in the Premium Service Lookup component when using a Dataverse/Dynamics CRM Connection Manager.
      • Fixed: The upsert action when working with the statecode field may not work properly in the Dataverse/Dynamics CRM destination component.
    • Dynamics NAV

      • Fixed: Datetime value in Filtering Conditions for a Dynamics NAV source component was sent as UTC, which should have been the current system local time.

  • Directory Services (Formerly SSIS Integration Toolkit for Directory Services)
    
    • Fixed: In an Active Directory source component, an invalid output error might be raised when the value for a multi-value field contains a semicolon delimiter.
    • Fixed: When writing to an array-type field in the Active Directory destination component, the delimited input value might be written as a single value.
  • HubSpot (Formerly SSIS Integration Toolkit for HubSpot)
    • Fixed: The HubSpot destination component may not actually perform the writing when the component is configured to use the Update action while its batch size is set to 1.
  • Microsoft Project Server (Formerly SSIS Integration Toolkit for Microsoft Project Server)
    • New: We have added a new "Azure AD OAuth Authorization Code" authentication type in the Project Server Connection Manager, which can be used to work with Project Server Online using modern authentication.
  • SharePoint (Formerly SSIS Integration Toolkit for Microsoft SharePoint)
    • New: We have added support for soft delete by adding the Use Recycle Bin option in the SharePoint destination component.
    • Enhancement: When using the REST connection in a SharePoint destination component, one of the lookup fields has been configured to use the Text Lookup feature. If the lookup fails, the component reports a wrapped error message, which can be difficult to follow. This has been changed to report a direct LookupFailureException, which should be more straightforward.
    • Fixed: The SharePoint Source may ignore the selected view option if it has been configured to read from a view that has an empty name.
    • Fixed: SharePoint source component using a REST connection may ignore the "up to" option's setting when the component is set to Download Version History.
    • Fixed: Taxonomy Lookup in a SharePoint destination component may not be performed against the full term store if the term store has a large number of records, while the SharePoint Connection Manager is using the REST service endpoint.
    • Fixed: The SharePoint source component may report an unexpected error when reading from <system>.Site using on-prem credentials against a SOAP SharePoint Connection Manager.
    • Fixed: SharePoint destination component does not accept synonym values when writing to a taxonomy field using the REST service endpoint.
  • NetSuite (Formerly SSIS Integration Toolkit for NetSuite)
    • New: We have added a new "Upgrade SOAP to REST" button in the NetSuite source and destination components to help migrate from NetSuite SOAP to REST service endpoint, as the SOAP service endpoint is gradually phased out by the vendor.
    • New: We have added support for discovery of custom segment metadata when working with the NetSuite REST API.
    • Update: The NetSuite Source Component shows warning messages when the custom field discovery fails.
    • Fixed: The NetSuite Destination Component may report a "System.Data.SqlTypes.SqlTruncateException: Numeric arithmetic causes truncation" under certain unique circumstances.
    • Fixed: The NetSuite Destination Component may not send all the children records in the Update or Upsert actions when using the SOAP service endpoint under certain unique circumstances.
    • Fixed: The NetSuite Destination Component may not send the decimal values correctly when the regional setting of the Windows system is using a non-English speaking locale.
    • Fixed: When working with a NetSuite Source Component that uses a SOAP connection, the Refresh metadata dialog may not update the scriptId if the column name did not change.
  • Oracle Marketing Cloud (Formerly SSIS Integration Toolkit for Oracle Marketing Cloud)
    • Update: We have updated metadata to support v2 contact object in Oracle Eloqua.
  • Salesforce (Formerly SSIS Integration Toolkit for Salesforce)
    • New: We have added the Client Credentials authentication option in the Salesforce Connection Manager.
    • New: We have added support for reading picklist values metadata in the Salesforce Source component in the Object Query Mode using queries such as SELECT * FROM Metadata.PicklistValues WHERE ObjectName = 'Account' AND FieldName = 'AccountSource'.
    • New: We have added support for SELECT * clause when using the Object Query mode in a Salesforce Source component, such as SELECT * FROM Account.
    • Update: We have updated the API support to the latest version 66.0. As a result of this, the Legacy SOAP Login authentication option in Salesforce Connection Manager has been removed, and it is not supported by existing connection managers either if used.
    • Update: We have removed the Legacy SOAP Login option support from the Salesforce Connection Manager, as it is no longer supported by Salesforce API v66.0 and above.
  • SAP (Formerly SSIS Integration Toolkit for SAP)
    • Fixed: SAP RFC Destination Component may not output all rows for the export table parameter.
    • Fixed: SAP Table Source might return duplicate rows as a result of pagination operations under certain situations when working with an S/4 HANA connection.
    • Fixed: When working with a SAP RFC Destination Component, the Table Import Parameter may not find the correct column to retrieve input data if the source and target use different column names.
    • Fixed: The Table import parameter may not create a dedicated DTS input in the SAP RFC Destination Component.
    • Fixed: The SAP RFC Destination Component may not report proper validation error messages when a non-optional table import parameter is set.
      
    • Fixed: The SAP RFC Destination Component may not send numeric values correctly when the operating system is using a non-default regional setting.
    • Fixed: The numeric value may not return correctly when using the option "Use Native Types on String-Backed Convertible Columns" in the SAP Table Source Component.
  • Team Foundation Server (Formerly SSIS Integration Toolkit for Team Foundation Server)
    • Fixed: After switching from "Source Type" to "Custom Query" in a Team Foundation Source Component, the component is not sending the custom query during runtime.
• Big Data
  • Enhancement: We have some performance enhancements when loading large files in EDI components at design time.
  • Fixed: The premium Data File components may raise an error when reading or writing to files that contain # characters in the file name.
  • Fixed: CDM Destination Component might crash when creating a new partition on an existing object.
• Conversion
  • Fixed: Space characters might be added to the JSON input value when using a JSON array as the source of a Decomposition component.
• Cloud Storage
  • New: We have added support for Managed Identity authentication in the Azure Blob Storage Connection Manager.
  • New: We have added support for the anonymous authentication mode to the Amazon S3 Connection Manager.
  • New: We have added file metadata reading and writing support in the Box source and destination components.
  • Update: We have updated SharedWithMe support to use the new endpoint when working with OneDrive connections.  This is an important update due to the deprecation of the old SharedWithMe endpoint effective November 2026.
  • Fixed: The Azure Blob Storage Connection Manager may report a "System.ArgumentNullException: Value cannot be null" error instead of a more appropriate message when the Connection Manager is set to use an empty AccessKey.
  • Fixed: The Box destination component may report a "System.ArgumentNullException: Buffer cannot be null" error when writing empty file content to a new file.
• Data Quality and Comparison
  • New: We have added a new 'Ignore Certificate Errors' option to the Address Verification Connection Manager.
  • Enhancement: Address Verification connection allows setting its throttling rate to 0 to disable service call throttling entirely.
  • Update: The Smarty Streets URL in the Address Verification Connection Manager has been updated to use its most current URL.
• Data Warehousing
  • Fixed: Client secret values might not be sent when using Azure Service Principal Authentication mode in the Databricks Connection Manager.
• Encryption and Compression Task
  • New: Compression Task now supports cloud connections as source and destination paths available in the SSIS Integration Toolkit.
  • New: PGP Encryption Task now supports cloud connections as source and destination paths available in the SSIS Integration Toolkit.
• Google Services
  • New: We have added a new <Default> API version option in the Google Ads Connection Manager. When specified so, the Connection Manager should use the default API version available for the release (including future versions), which can simplify software upgrades or downgrades. Using this option, your Connection Manager is no longer tied to a specific version, which can create issues when the software is upgraded or downgraded.
  • New: Google Ads Destination Component now supports the Conversion Support Service endpoints.
  • Fixed: Google Ads Destination Component may send requests as a batch for endpoints that do not support batch requests.
• HTTP / Web Services
  • New: The HTTP Requester Task component now supports outputting and exporting various parts of the HTTP response after execution.
  • Enhancement: The 401 and 403 error codes are now added as additional default error codes in the HTTP Connection Manager.
  • Fixed: The authentication signature might be calculated incorrectly when connecting to Magento through the HTTP Connection Manager using the OAuth1 authentication.
  • Fixed: When using OAuth Client Credentials mode in the HTTP Connection Manager, the scope request parameter may be sent automatically even if it is not explicitly configured.
  • Fixed: The Monday.com Destination Component may report a "Value cannot be null" error when choosing a nested query parameter from the "Field Selection..." window.
  • Fixed: The GraphQL Destination Component may report a "The given key was not present in the dictionary" error when certain fields have been selected in the "Field Selection..." window.
• JSON & XML Processing
  • Enhancement: JSON Source and JSON Extract components can better handle the situation where there are node type discrepancies. For instance, if a node is configured to be a JSON array but the actual data is a JSON object, the components now skip such fields and report a warning message in the DTS execution log.
  • Fixed: The JSON Source component may raise the error "Access to the path '' is denied" when loading a file from a folder where the user has read-only permissions.
• Message Queue
  • New: We have added support for Azure OAuth Client Credentials authentication in the Kafka Connection Manager.
  • New: We have added a Timeout option when working with the Close Shared Sessions action in the Message Queue Task that uses a Kafka connection.
  • Fixed: Azure Service Bus source or destination components may report a "method not found" type of error when using Visual Studio 2026.
  • Fixed: In the Kafka Source and Destination components, if the key column was mapped and the installed build is upgraded from an earlier version up to a v25 release (including v25.1 and v25.2), the runtime may report the error "Unable to cast object of type 'System.String' to type 'System.Byte[]", and such upgraded Kafka source component might report the key column to be a byte type even it is actually a text type.
  • Fixed: The Message Queue Task component using Kafka connections may raise an "Array cannot be null" error when the key field is not mapped.
  • Fixed: The Message Queue Task component using Kafka connections may run successfully even when the Kafka Connection Manager has a configuration error.
• NoSQL Components
  • New: We have added GridFS support in the MongoDB Source and Destination components.
  • Fixed: When working in Visual Studio 2022, the MongoDB Connection Manager may report an "Object of type 'System.Int32' cannot be converted to type 'System.Nullable" error if MongoDB is the selected Scheme option.
• Security Management Components
  • Fixed: Azure Key Vault Task component may report a "Missing Metadata: true Header" error when its Connection Manager is using the Managed Identity option.
• Premium File Pack
  • New: We have added support for partially updating metadata in the Refresh component in the Premium Flat File Destination Component.
  • Fixed: Premium Flat File source component may fail to return all records when a length-related error occurred in the middle of the process if the component is configured to use the Error Handling option.
  • Fixed: Premium Flat File destination component does not save any length changes if the field is not mapped.
  • Update: We have removed the "ContinueOnError" option from the File Transfer Task component in its Advanced Property options. Such requirements are better served via the error handling options in the task component.
  • Fixed: Setting a SFTP Connection Manager's Proxy Type option to <None> did not disable and clear out the Proxy Server and Proxy Port options.
• Premium Data Flow Components
  • New: We have added support for "Suppress File Not Found Errors" and "Suppress Table Not Found Errors" options in the PDF source component's error handling page.
  • New: We have added support for Google AlloyDB and Premium SQL Server as the newly available connections in the Premium Slowly Changing Dimensions component.
  • New: We have added support for Bulk action in the Premium SQL Server destination component when working with a Microsoft Fabric Data Warehouse connection.
  • Update: We have updated the PDF libraries for improved stability of the PDF source component.
  • Fixed: The skip rows option in the Premium Excel Source Component may not skip rows that are completely empty for the region specified, but there are adjacent tables outside of the region that contain data on the same rows in the same sheet.
  • Fixed: The skip rows option may not work properly in the Excel Source Component for rows that contain empty cell values.
    
  • Fixed: Upgrading from earlier versions to v25 releases might reset cell format when writing in the Premium Excel destination component.
  • Fixed: The ODATA Destination component may report an error "Invalid response section returned, no boundary information was found in the Content-Type header of the section" when using a batch request.
  • Fixed: Under certain circumstances, the ODATA Connection Manager may report a "NullReferenceException" error when using a SAP connection.
  • Fixed: The ODATA Connection Manager may report a "NullReferenceException" error when the Base URL value has a trailing space.
  • Fixed: The ODATA Connection Manager may report a "NullReferenceException" error when the API response code is 404.
  • Fixed: Under certain circumstances, the PDF file may not get closed properly after the PDF Source component has finished the process, which can cause an error if another process tries to process or access the file right after.
  • Fixed: The SQL Server components may report a "Timeout" error when used in a loop repetitively.
• REST Components
  • New: We have added a new JQL Search API Version option to the REST Connection Manager when working with a Jira connection.
  • New: We have added a new Read Mode option in the Smartsheet Source component, which contains the options for how the component returns cell values. The available options are "All", "Actual Values" and "Display Values".
  • New: We have added support for PKCE in the OAuth Authorization Code when working with the Power BI REST Connection Manager.
  • New: We have added pagination support when working with the Get sheet service call in a Smartsheet REST source component.
  • New: We have added support for custom field discovery in Zoho Expense REST components.
  • Enhancement: In a JSON Source or Extract component, when a node is configured as an array of objects (output) but it is actually a JSON object (complex fields), we now report a warning message indicating the discrepancy in the SSIS execution log, and the field will be simply skipped. When this happens to a REST source component, it is considered a metadata error, and the component will fail during runtime, so a fix of such metadata configuration is required.
  • Update: We have updated metadata in ADP REST components to support more endpoints.
  • Update: We have updated metadata in Calendly REST components to support more endpoints.
  • Update: We have updated metadata in Crelate REST components.
  • Update: We have updated the list of scope options for the Client Credential authentication mode in the Discord REST Connection Manager.
  • Update: We have updated metadata in Duo Security to support new endpoints, along with some filter parameter support.
  • Update: We have updated the default API version of Facebook Business to V24.0.
  • Update: We have updated the default API version of Facebook Messenger to V24.0.
  • Update: We have updated metadata in the endpoint "Read posts by page" when working with the Facebook Business REST source component.
  • Update: We have updated metadata in the endpoint "Instagram insight" when working with the Facebook Business REST source component.
  • Update: We have updated metadata in Freshsales REST components to support additional new endpoints and parameters.
  • Update: We have updated metadata for the customer object in Maxio REST components to support some previously missing fields.
  • Update: We have updated metadata in Okta REST components.
  • Update: We have updated metadata in OneLogin REST components.
  • Update: We have implemented a new design for the Replicon lookup endpoints. We now support filterexpression internally, and custom field discovery is available for these endpoints.
  • Update: We have added support for more instance types when working with the Smartsheet REST Connection Manager.
  • Update: We have updated metadata in Webex REST components
  • Update: We have updated Yammer OAuth Authentication to use Microsoft Authentication flow. The old OAuth Authentication has been deprecated starting from July 1, 2025.
  • Update: We have updated the GoToWebinar Connection Manager to use the new OAuth Authentication token retrieval.
  • Fixed: The OAuth Authentication may not work properly when a non-default instance type is selected in the Smartsheet REST Connection Manager.
  • Fixed: When working with the Sandbox option in the eBay Connection manager using the OAuth Authentication mode, the actual service calls might be directed to the incorrect instance.
  • Fixed: Pagination might not work properly when working with a Jira REST connection, using the Search for issues version 2 endpoint.
  • Fixed: Maxio REST components might report a "Property with the same name already exists on object" error when there is a custom field that has the same name as a system field.
  • Fixed: Smartsheet REST Source component may not return any data when the column name contains a dot.
  • Fixed: Smartsheet REST Source Component might have incorrect data types for some columns when working with one of the endpoints under the Groups category.
  • Fixed: Smartsheet REST Source Component may report a "KeyNotFoundException" error when extra fields, such as 'attachments' or 'discussions', are enabled in the Sheet object.
  • Fixed: The create batch payment service call may not work correctly in an Xero REST connection.
  • Fixed: The ID column may not be returned from the Zoho Sheet REST source component when reading from sheets.
• Timing and Automation Components
  • New: We have added a new DateTime output option for the Time Conversion component. These changes introduce a new metadata version. After saving the component using the new version, the component cannot be opened in an older version of SSIS Productivity Pack due to the new metadata version.