What’s New
In this release we focused on mainly on bug fixes and minor enhancements.
Full Notes: https://zappysys.com/onlinehelp/ssis-powerpack/scr/release-notes.htm
Version 2.9.1.10310 [Mar 12, 2019]
New Features/Improvements
- NEW: Amazon Storage Connection – Dll load performance improvements
- NEW: Export JSON, XML, CSV Task – Change PathAccess Mode label to Save Mode, Also rename Variable access mode to [Save content to Variable] to avoid confusion with other Path modes (Most users think Variable is save to path)
- NEW: JSON Source, XML Source, CSV Source – Continue without error if file not found
- NEW: JSON Source, XML Source, CSV Source – Provide Max Row Count Expression and Max Row DataPath Expression to support scenarios like Magento
- NEW: Secure FTP Connection Manager – Add new property OtherOptions to expose 50+ new SFTP / FTP options which were not possible to set before (See help file full all possible options now available to set)
- NEW: Secure FTP Connection Manager – Add new SFTP option LegacyGroupExchangeMode to force using legacy or standard form of SSH Diffie-Hellman group exchange packet
- NEW: Secure FTP Connection Manager – For some servers due to group exchange issue you may get error – Requested service is not implemented
- NEW: Secure FTP Connection Manager – Provide an easy way to populate current server fingerprint on Advanced Tab
Bug fixes
- FIX: All Source Components – After Sorting Columns you cannot remove or add columns from the grid
- FIX: CSV Generator Transform – Batch Size Setting is not displayed on Single
- FIX: CSV Generator Transform – Unwanted buttons visible in toolbar / right click menu in the mapping designer
- FIX: Excel Connection Manager – You may get error on file load if it contains formula with certain characters like “:” (Error : Unexpected character “:” at pos XXXXX on formula: XXXXXXXXXX)
- FIX: Export CSV, JSON, XML File Task – Once you change Character Encoding option there is no way to set it back to blank, also make a note that use either Encoding OR characterset (not both)
- FIX: Google Analytics Source – You may get an error sometime – String was not recognized as a valid datetime
- FIX: HTML Email Task – table_no_encode format specifier works only in design mode when you preview but at runtime doesnt work
- FIX: Installer not detecting SSIS 2017 when you have latest version of SSDT for Visual Studio 2017 installed
- FIX: JSON , CSV, XML Generator Transform – Batch Size setting greater than 100 not allowed
- FIX: OAuth Connection Manager – AWS v4 Signature Provider doesnt work for AWS Api Gateway exposed URLs (e.g. https://xxxx.execute-api.xxxxx.amazonaws.com/part1/part2/somename )
- FIX: Redshift Destination, PostgreSql Destination – You may get error abount invalid number of columns when your system is using comma as decimal Separator
- FIX: Salesforce Destination – Bulk mode does not work
- FIX: Salesforce Source – When you preview data in UI – You may get error – Non-grouped query cannot have LIMIT clause (e.g. This doesnt work select count(Id) cnt from Account )
- FIX: Salesforce Source – You may get Object reference not set error when you execute COUNT query without column name (e.g. select COUNT() from Account )