SSIS PowerPack v2.9.8 released

Posted on by
Contents hide
1 New Features/Improvements
2 Bug fixes

New Features/Improvements

  • NEW: CSV File Destination, Export CSV Task, CSV Generator Transform – Give option to escape Quote character inside value as per RFC4180
  • NEW: Export JSON Task – Provide an option (DoNotOutputParentIfChildRowNotFound) to exclude empty array property (hide from output if no children found under array node)
  • NEW: Export JSON Task – Provide an option (DoNotOutputParentIfNestedPropertiesNull) to exclude null nested property (hide parent from output if all nested properties are null)
  • NEW: Export XML File Task, XML Generator Transform, XML File Destination – Right click menu options not showing correctly (i.e. Add XML attributes under selected element is disabled)
  • NEW: Export XML Task – Provide options to hide empty nodes from output (DoNotOutputEmptyNestedAttribute)
  • NEW: Export XML Task, Generate XML Transform, XML File Destination – Allow adding Attribute at root level via Context menu
  • NEW: Export XML Task, XML Generator Transform, XML File Destination – Add option in layout designer to add Static Attribute under element
  • NEW: General – All HMAC function – Provide a way to treat secret as non-base64 string) (append –non-base64 at the end of secret)
  • NEW: HTTP Connection Manager – Provide an option to treat HMAC Password / Secret as Non-Base64 string
  • NEW: JSON Generator Transform, JSON File Destination – Add encoding option (i.e. Utf16, Utf8, Ascii)
  • NEW: JSON Generator Transform, JSON File Destination – Provide options to hide empty nodes from output (Two new properties DoNotOutputEmptyNestedAttribute, DoNotOutputEmptyArrayAttribute)
  • NEW: JSON Source, XML Source – Support Custom column list in Complex 2D Transform
  • NEW: Redshift Data Transfer Task – Provide option to specify culture for exported data (e.g Numeric format) – Default is set to No-Culture
  • NEW: REST API Task – Add Option to append new line for MultiPart Requests (Some Servers need \r\n after boundary)
  • NEW: Secure FTP Task, Amazon Storage Task, Azure Storage Task, Advanced File System Task – Always Trim Source and Target Paths before executing operation
  • NEW: SFTP Connection Manager – Add SFTP option KeepAliveDuringTransfer to avoid connection drop during big file transfer
  • NEW: Web API Destination – Add Option to append new line for MultiPart Requests (Some Servers need \r\n after boundary)
  • NEW: XML File Destination – Set Default Mode to Output one Document for all input rows
  • NEW: XML Generator Transform, XML File Destination – Add character set option (i.e. encoding=”Windows-1252″ or ISO-8859-1)
  • NEW: XML Generator Transform, XML File Destination – Provide options to hide empty nodes from output (DoNotOutputEmptyNestedAttribute)

Bug fixes

  • FIX: After upgrading to new version you may lose Dropdowns for some properties (grid mode) in Data flow components
  • FIX: Amazon Storage Task, Azure Storage Task – Sort along with Top N setting is not working
  • FIX: Azure Storage Task – Read file content into variable action may return junk characters for certain file encoding
  • FIX: CSV File Destination – Append option not working
  • FIX: CSV File Destination, Secure Ftp / Azure / Amazon S3 CSV File Destination – Column names not generated in file when zero upstream rows
  • FIX: Export CSV File Task, CSV File Destination, CSV Generator Transform – Custom Row Delimiter is not used for Header row (It always uses CRLF after header row)
  • FIX: Export Excel Task – Adding task inside loop with [enable Template Engine] option and [Throw error if source dataset is empty] option ON, package doesn’t fails even though zero row found in source dataset
  • FIX: Export Excel Task – Failed to Overwrite Excel when Stored Proc used as source
  • FIX: Export JSON Task – Value array does not join on UNIQUEIDENTIFIER column – You may get error – Failed to convert parameter value from Guid to a String
  • FIX: Export JSON Task, Export XML Task – You may get error Incorrect syntax near ‘=’ when you enable Custom Layout and main query has vertical bar somewhere (e.g. | )
  • FIX: Export XML Task, XML Generator Transform, XML File Destination – Convert to Attribute to Element is allowed even though Node has children
  • FIX: Export XML Task, XML Generator Transform, XML File Destination – Provide option to add Namespace URL in any element node (not just root level node)
  • FIX: General – Document Numeric value associated with Enum (e.g Action Option – in Advanced File System Task)
  • FIX: JSON Generator Transform – Incorrect rows generated when you choose Single Dataset Mode with BatchSize=1 (You may see less rows in some case)
  • FIX: JSON Source, XML Source – If you supply less than actual columns in 2D Transform then you may get error – Index was out of range
  • FIX: JSON Source, XML Source – If your 2D Transform using Complex Transform and you have blank column name – You may get error – Column ” does not belong to table nosqldata.
  • FIX: JSON Source, XML Source – Pagination via POST Body always start Page number at 1 regardless Variable Value in UI Preview Mode (at run time works as expected)
  • FIX: OAuth Connection – Retry option cause issue with Amazon MWS API
  • FIX: OAuth Connection Manager – Authorization header with Basic Authentication is not included in Token request (This cause issue for some API like SnowFlake)
  • FIX: REST API Task, JSON / XML / CSV Source, Web API Destination – You may get error if server returns HTTP header with space in name – System.Net.WebException: The server committed a protocol violation. Section=ResponseHeader Detail=CR must be followed by LF
  • FIX: Upsert Destination – Throw error for unsupported outputs in PostgreSql and Redshift Outputs
Posted in Announcements.