SSIS PowerPack 6.0.0 Released

Announcements SSIS PowerPack
1

Version 6.0.0.10308 [Mar 03, 2026]

To view full release notes (including previous versions): click here
Download Latest Version

New Features/Improvements

  • NEW: Amazon / Azure / Secure FTP Task - Added more log and timestamp tolerance for Sync - Avoids re-transfer for unchanged files
  • NEW: Amazon / Azure / Secure FTP Task - Expose a new property to retail LastModifiedDate same as source file after download operation
  • NEW: Amazon / Azure Storage Task - Enhanced Sync action to skip only when target is same or newer AND same size
  • NEW: API Connection Manager - Added Validation for API Service Url (Now if user enter custom URL it will warn it to choose from the dropdown instead)
  • NEW: API Connection Manager - Improved Token Generation UI - Added non blocking flow, enhanced process scanning performnace
  • NEW: API Connector - All - Improved connector descriptions
  • NEW: API Connector - Azure DevOps - Add support for On-Premises Azure DevOps Server
  • NEW: API Connector - Azure DevOps - Added new authentication options: User Credentials (delegated OAuth flow) plus Azure App‑based authentication (service principal via client credentials or certificate); deprecated legacy OAuth and PAT methods
  • NEW: API Connector - Azure DevOps - Updated steps to use new Azure Portal for app registration
  • NEW: API Connector - Google Calendar - [BREAKING] Switched to new ZappySys app when UseCustomApp=False
  • NEW: API Connector - Google Calendar - Add support for pagination in List Calendars endpoint
  • NEW: API Connector - Google Calendar - Added many new columns in list_events, create_event, and update_event endpoints
  • NEW: API Connector - Google Calendar - Added new columns (StartsOn, EndsOn, Location, etc.) to get_event and list_events endpoints
  • NEW: API Connector - Google Calendar - Added new parameter SendUpdates for create_event and update_event
  • NEW: API Connector - Google Calendar - Added new parameters (Start Time, End Time, etc.) to list_events endpoint for enhanced filtering
  • NEW: API Connector - Google Calendar - Added support for pagination in List Calendars endpoint
  • NEW: API Connector - Google Calendar - Added support for reading events for all calendars
  • NEW: API Connector - Google Calendar - Added support for supplying attendees, attachments, and reminders as raw arrays of emails
  • NEW: API Connector - Google Calendar - Added UserId parameter for list_calendar endpoint to support Service Account Authentication
  • NEW: API Connector - Google Calendar - Use new default app (old app was blocked for many users)
  • NEW: API Connector - Google Search Console - Adde support for the DimensionFilterGroups parameter in get_report (useful to get keyword / brand report)
  • NEW: API Connector - JIRA - Retry on error code 429 (Too many api requests)
  • NEW: API Connector - OData - Added new endpoints get_metadata_tables and get_metadata_columns
  • NEW: API Connector - OData - Added new endpoints get_metadata_tables, get_metadata_columns.
  • NEW: API Connector - OneDrive - Allowed use of Target Folder Path rather than just Id in copy/move/rename item endpoints
  • NEW: API Connector - Outlook Mail - Added support for reading Excel attachments directly from Outlook Mail
  • NEW: API Connector - Outlook Mail - Support Reading Excel Attachments Directly from Outlook Mail
  • NEW: API Connector - ServiceNow - Add new attachment-related endpoints to perform list/download/upload operations (get_attachments, download_attachments, download_attachments_by_parent_search, get_attachments_by_parent_search and download_attachment_single)
  • NEW: API Connector - ServiceNow - Add new endpoint get_record_labels to retrieve UI labels (tags) for a specific parent table record with optional filtering
  • NEW: API Connector - ServiceNow - Add new option DateTimeValueHandling at connection level and EndPoint level (e.g. for get_table_rows) to treat DateTime as DateTime2 (Useful for Gateway to avoid - Error converting data type DBTYPE_DBTIMESTAMP to datetime)
  • NEW: API Connector - ServiceNow - Add two new OAuth connection types (e.g. Client Credentials Grant, User Credentials Grant).
  • NEW: API Connector - ServiceNow - Added get_table_row_count endpoint to get row counts for specified tables or filters
  • NEW: API Connector - ServiceNow - Added new attachment-related endpoints for list/download/upload operations
  • NEW: API Connector - ServiceNow - Automatically mapped large text fields to DT_NTEXT to prevent truncation of descriptions and comments
  • NEW: API Connector - ServiceNow - Used system-defined length (max_length) from metadata rather than fixed 2000 chars for string columns
  • NEW: API Connector - SharePoint Online - Allowed use of Target Folder Path rather than just Id in copy/move/rename item endpoints
  • NEW: API Connector - Shopify - Added OAuth Authorization Code Grant (3-legged) authentication option for apps built in the Shopify Dev Dashboard
  • NEW: API Connector - Shopify - Changed default API version to 2025-01 from 2023-01
  • NEW: API Connector - Zoom - Added a new endpoint list_meetings_all to show scheduled (future) meetings for all users all users
  • NEW: API Connector - Zoom - Added new endpoint list_past_meetings_all to show past meetings for all users
  • NEW: API Connector Framework - Add option ExpandContinueOnError to continue showing remaining list on expand failure of DataEndPoint invoke
  • NEW: API Connector Framework - Add two properties CustomErrorRegexPatterns and CustomErrorTexts to show custom error when endpoint fails
  • NEW: API Connector Framework - Added CustomErrorRegexPatterns and CustomErrorTexts properties to show custom errors on endpoint failure
  • NEW: API Connector Framework - Added ExpandContinueOnError option to show remaining list on expand failure of DataEndPoint
  • NEW: API Connector Framework - Added new property OptionsEndPointErrorHelp to show custom error help when OptionsEndPoint fails on UI
  • NEW: API Connector Framework - Added RowFilter parameter to support advanced client-side filtering with SQL expressions
  • NEW: API Connector Framework - Added support for <Desc> node with CDATA in all configuration nodes
  • NEW: API Connector Framework - Allow new Property Param DateTimeValueHandling to treat datetime as DT_DBTIMESTAMP2 (datetime2 in MS SQL) and DT_STR (varchar(30) in MS SQL)
  • NEW: API Connector Framework - Changed default DataEndPointWhere behavior to continue on errors; added DataEndPointWhereThrowOnError property
  • NEW: API Connector Framework - Fixed SaveContentAsBinary for MultiPart responses in download endpoints
  • NEW: API Framework - Add Slug property for all Api Objects (Useful to expose Example as URL where Lable can be changed but slug can remain same)
  • NEW: Dynamics CRM / Dataverse Destination - Fixed issue where update operation failed with error regarding specified cast
  • NEW: General - Add support for SSIS 2025 / SQL Server 2025
  • NEW: General - Added 46 new Source / Destination Toolbox items for existing API Connectors
  • NEW: General - Added a new option (filter) in placeholder function FUN_HTTP_READ and FUN_HTTP_READ_BINARY to extract specific attribute using JsonPath / XmlPath or Regex from HTTP response (e.g. $.token.value)
  • NEW: General - Added date format option for FUN_TO_UTC_DATETIME and FUN_TO_LOCAL_DATETIME
  • NEW: General - Fixed bad format in FUN_NEW_GUID by using default format "N" instead of raising an exception
  • NEW: JSON / XML / CSV Source - Increased scan limit from 300 to 3000 records for local files to guess datatypes
  • NEW: OAuth Connection Manager - Added Provider for Google Calendar API
  • NEW: OAuth Connection Manager - Added Provider for Google Search Console API
  • NEW: OAuth Connection Manager - Fixed issue where response sent blank value for "expires_in" if no traffic access token was parsed
  • NEW: OAuth Connection Manager - Improved Token Generation UI with non-blocking flow and enhanced process scanning
  • NEW: OAuth Connection Manager - New Provider for Youtube API
  • NEW: OAuth Connection Manager - Updated description for Extra Auth/Token Attributes
  • NEW: Salesforce Connection Manager - Allow Client Credentials Grant Authentication - Non-Interactive Run-As credentials
  • NEW: Salesforce Connection Manager - Reduce default permissions needed for OAuth (i.e. change scope from "full" to "api" on Advanced Tab (just allow CRM API) rather than all)
  • NEW: Upsert Destination - SQL Server / PostgreSql / Redshift - Give option to Exclude Column(s) in from data compare to detect updated rows when you choose Row Compare method as Keys+Columns (Right now all mapped columns are used for compare)
  • NEW: XML Source - Fixed issue where file was locked after data flow execution when XML failed to load

Bug fixes

  • FIX: Amazon / Azure Storage Task - Changed Sync action to compare not only by Modified Date but also size
  • FIX: Amazon / Azure Storage Task - Changed Sync action to ignore file name case during compare (Previous one was Case-Sensitive)
  • FIX: Amazon / Azure Storage Task - Fixed Recursive option if Sync with retain folder structure is selected
  • FIX: Amazon / Azure Storage Task - Fixed transfer summary for Sync operations to show row summary only once
  • FIX: Amazon / Azure Storage Task - Hide Recursive option if Sync with retain folder structure is selected
  • FIX: Amazon Redshift Data Transfer Task - Fixed issue where it showed wrong number of processed files for Serverless Cluster
  • FIX: API Connector - Azure DevOps - Added support for On-Premises Azure DevOps Server
  • FIX: API Connector - Azure DevOps - Update steps to uase new Azure Portal for app registration
  • FIX: API Connector - JIRA - UpdatedAfter parameter not working for get_worklogs_after endpoint, now UpdatedAfter parameter is working as expected
  • FIX: API Connector - JIRA - You may get error (400 Bad request) when you lookup Issues table by Id (in WHERE clause)
  • FIX: API Connector - OneDrive - Fixed issue where FileId selection showed wrong ID in builder
  • FIX: API Connector - Outlook Connector - Fixed issue where download_message_attachments generated duplicate or malformed filenames when contentId was missing
  • FIX: API Connector - ServiceNow - Queries with selected fields in get_table_rows endpoint returned zero results due to an incorrect parameter separator ('&') instead of a comma
  • FIX: API Connector - SharePoint Online - Added support for Update/Insert Multi-Select LookupId / Person datatype fields
  • FIX: API Connector - SharePoint Online - FileId Selection shows wrong Id in builder
  • FIX: API Connector Framework - Fixed DT_DBDATE type incorrectly sending time part causing server-side errors
  • FIX: API Connector Framework - Fixed typos in several exposed properties (changed "Contine" to "Continue")
  • FIX: API Connector Framework - Fixed UI freezing and slow loading for dropdowns with many entries
  • FIX: API Connector Framework - MetaDetectionOrder Property with MergeStaticDynamic value not working
  • FIX: API Connector Framework - SaveContentAsBinary may not work correctly for many download endpoints if response is MultiPart (e.g. ServiceNow Usecase)
  • FIX: API Framework - Added Slug property for all API Objects to allow label changes while slug remains persistent
  • FIX: API Source, API Destination - Duplicate log entries generated
  • FIX: Execute PostgreSQL Task - Fixed validation logic so it doesn't show an error after setting the connection
  • FIX: General - Fixed placeholder functions FUN_FILE_WRITE and FILE_WRITE_BINARY to skip write if path starts with single slash
  • FIX: General - Rename [Error Retry Settings] tab to [Throttling & Error Retry] in various UI elements
  • FIX: Installer - Fixed issue where it did not detect runtime correctly and show information during repair when only SSIS 2022 was installed
  • FIX: OAuth Connection Manager - When response sends blank value for "error" attribute no access token is parsed
  • FIX: OAuth Connection Manager - When token response is blank (e.g. bad credentials sent and API sent blank response - Status Code 204) then you may get misleading error (Value cannot be null. Parameter name: result)
  • FIX: PostgreSQL Source - Fixed Bool array output issues
  • FIX: PostgreSQL Source - Fixed issue where more than one dimension returned a bad value
  • FIX: PostgreSQL Source - Fixed issue where Query with Range Datatype failed with "Column requires a valid Datatype" error
  • FIX: REST API Task / Web API Destination - Fixed issue where test request failed with misleading error
  • FIX: REST API Task, JSON / XML / CSV Source - Fixed ResetResponse not clearing MultiPart Stream flag causing Stream Parser errors
  • FIX: Salesforce Connection Manager - Fixed issue where UI reset on load when choosing OAuth Credentials Type and using custom Auth/Token URL
  • FIX: Salesforce Connection Manager - When you choose OAuth Credentials Type and use custom Auth/Token URL it gets reset on UI load (Also Changing Auth Type resets URLs)
  • FIX: Salesforce Source - Fixed Bulk mode issue when reading Unicode / Special characters
  • FIX: Upsert Destination - In new VS2022+ / SSIS designer with SQL 2025 Support - Create new ADO.net connection uses Microsoft.Data.SqlClient as default rather than System.Data.SqlClient
  • FIX: Upsert Destination - PostgreSQL / Redshift - Fixed error where expression was of type character varying but column was of type text
  • FIX: Upsert Destination - PostgreSQL / Redshift - Fixed issue where Primary Key was not auto-detected when Metadata Refresh happened on UI
  • FIX: Upsert Destination - PostgreSql / Redshift - When key is uuid you get error - operator does not exist: character varying = uuid
  • FIX: Upsert Destination - PostgreSql / Redshift as target - You may get error: column "SomeColumn" of relation "zappysys_10112zzzz_ea6zzzzzzz" does not exist - Mostly happens when staging table is set to auto create and column names not in lower case
  • FIX: Upsert Destination - PostgreSQL/Redshift UI - Fixed issue where prompt for missing index was not shown in some cases