Version 5.7.0.10627 [Jul 13, 2025]
For full release notes click here
New Features/Improvements
- NEW: All MongoDB Components - Add support for MongoDB 8.1 - SSSIS 2017 or higher only
- NEW: API Connection Manager - On Auth Help popup when you click any link it opens old IE browser rather than OS default Browser (i.e. Chrome, Edge, Firefox)
- NEW: API Connector - Google Ads - Added support for v20 and removed depricated versions (i.e. v17, v18, v19)
- NEW: API Connector - Google Ads - Generate more accurate metadata with all columns supported by the resource, better names for column (e.g. rather than app.id call it AppId)
- NEW: API Connector - Google Ads - Table outputs max 100 fields if more than 100 fields found
- NEW: API Connector - Google Search Console Connector - New connector to read google search console data (Organic traffic)
- NEW: API Connector - JIRA - Add support for cascade selection field (parent-child dropdown)
- NEW: API Connector - OneDrive - Added an option for get_excel_worksheet and get_excel_worksheet_autodetect to read the formatted text values for date time or other types (e.g. rather than 44563.25 return 01/03/2022 06:00)
- NEW: API Connector - OneDrive - Added response caching for get_excel_worksheet and get_excel_worksheet_autodetect endpoints for better speed and reduced API calls
- NEW: API Connector - OneDrive - Added support for Certificate Authentication (Sign JWT using Certificate File / Private Key - *.p12, *.pem, *.pfx)
- NEW: API Connector - OneDrive - Remove unused scopes Sites.Read.All, Sites.ReadWrite.All
- NEW: API Connector - SharePoint - Added an option for get_excel_worksheet and get_excel_worksheet_autodetect to read the formatted text values for date time or other types (e.g. rather than 44563.25 return 01/03/2022 06:00)
- NEW: API Connector - SharePoint - Added response caching for get_excel_worksheet and get_excel_worksheet_autodetect endpoints for better speed and reduced API calls
- NEW: API Connector - SharePoint - Added support for Certificate Authentication (Sign JWT using Certificate File / Private Key - *.p12, *.pem, *.pfx)
- NEW: API Destination - Mapped Param may not work if AllowParamBindForLayoutMap=True (OneDrive, SharePoint, SmartSheet Connectors Affected)
- NEW: BREAKING CHANGE - All MongoDB Components - Dropped support for older MongoDB (e.g. v3.5 or lower) in SSIS 2017 or higher - You may get error - server at {server-name} reports wire version {number}
- NEW: BREAKING CHANGE - All MongoDB Components - For SQL 2017 or higher now requires .net framework 4.7.2 rather than 4.6.2 (Most OS already have .net 4.7.2 pre-installed but incase you run older OS then must apply updates else you may get error in some cases)
- NEW: Excel Connection Manager - Input string was not in correct format
- NEW: Export Excel Task - Show enhanced notes about Excel Template engine
- NEW: General - Add new features for FUN_PROPERCASE function (new parameters for case_type for ProperCase or camelCase, segment_split_character, search_for_regex_pattern, replace_with, segments_to_remove )
- NEW: General - FILE_CREATE_DATE and FILE_LASTEDIT_DATE - Add new parameters (date_format and is_utc)
- NEW: HTML Email Task - Show Placeholder watermark and show Edit/Insert Variable button next to each field
- NEW: HTML Email Task, Logging Task - Allow to format / Add Total Row for Object Type Resultset Variable (ADO.net Table) with three additional system columns ( __Config__, __TdAttrs__ and __TrAttrs__ )
- NEW: MongoDB Connection Manager - Add support for GSSAPI/Kerberos and LDAP (i.e. PLAIN) - SSSIS 2017 or higher only
- NEW: MongoDB Connection Manager - Give an UI option to load connection string for native MongoDB URL format (e.g. mongo://****) or for ZappySys format (e.g. Host=***;Database=***)
- NEW: MongoDB Source - Add support for mongodb+srv format (Add plus prefix in the host name (e.g. +mycluser.name.mongodb.net ) - this helps with Atlas or other MongoDB providers to auto discover nodes and options) - SSSIS 2014 or higher only
- NEW: MongoDB Source - Add support for Relaxed JSON output in Raw Document mode - Upgrade to Driver v3.4
- NEW: MongoDB Source - Better support for high precision decimal type (e.g. { "value": { "$numberDecimal": "123456789.123456789123456789" } } )
- NEW: MongoDB Source - SQL 2019 or higher now supports many new Aggregate operators (i.e. $merge, $search, $set, $unset, $unionWith, $replaceWith, $setWindowFields, $densify, $fill, $documents, $lookup.pipeline, $function, $accumulator, $sortByCount ... more)
- NEW: MongoDB Source, MongoDB Destination - Add support for extra logging - SSSIS 2017 or higher only
- NEW: OAuth Connection Manager - New Provider GenericJwt for Private Key Authentication (Sign JWT using Certificate File / Private Key - *.p12, *.pem, *.pfx)
- NEW: Secure FTP Connection Manager - Detect FIPS setting when Negotiation fail error happens and report a workaround (Better message)
Bug fixes
- FIX: API Connection Manager - Google BigQuery Connector - [AuthorizationCode parameter] Value cannot be null
- FIX: API Connectors - SharePoint - list_folders endpoint look for *.xls files rather than folders
- FIX: Excel Source Connection Manager - Test Failed: String was not recognized as a valid DateTime.
- FIX: Export Excel File Task - Charts generated using Report Template Engine may show blank on Excel Online Version (Works ok in Desktop)
- FIX: General - Some times Loading UI message not showing
- FIX: HTML Email Task - GMail or some other email provider may not show Style correctly (Becuase Style element was added in <BODY> rather than <HEAD>
- FIX: JSON / XML / CSV Components - Visual Studio crash happens when you try to remove columns by unchecking (Only happens when column you removing is not found in the source data / data is blank in case of Variable mode used)
- FIX: JSON Source - Pagination stops randomly for counter based pagination mode when array filter with condition or nested field used (e.g. $.somearray[?(@comments==0)] --OR-- $.somearray[*].nestedfield )
- FIX: MongoDB Connection Manager - UserId or Password with slash ( / ) or some other characters do not encode correctly (RFC 3986)
- FIX: MongoDB Source, Amazon DynamoDB Source, Azure Table Source - Error details missing in error log (It just says Failed)
- FIX: OAuth Connection Manager - CacheToken option doesnt work in some cases when Expiration Time is not returned in token response
- FIX: OAuth Connection Manager - For OAuth1 sometimes bad signature generated (Specially you have Query parameters in URL with special chars e.g. [ ] )
- FIX: REST API Task - Saving Edit Placeholder UI replaces \t , \r and \n with Tab character or New Line