SSIS PowerPack v2.9.1 released (Maintenance Release)

What’s New

In this release we focused on mainly on bug fixes and minor enhancements.

Full Notes:

Version [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. )
  • 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 )
Posted in Announcements, SSIS PowerPack.