SSIS Integration Toolkit

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
• Mayor 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 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 "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 statecod 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. 
    • 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. 
• 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. 
  • Fix: 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 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.