SSIS PowerPack v3.0.0 Released (with SQL Server 2019 Support)

We are excited to add support for SQL Server 2019 in this version along with many other improvements.

Version 3.0.0.11216 [Dec 20, 2019]

New Features/Improvements

  • NEW: Add Support for SSIS 2019 (SQL Server 2019)
  • NEW: General – Indicate NULL cell in Preview Grid
  • NEW: General – Show LONG TEXT in Preview Grid – Add right click option to Copy Cell
  • NEW: JSON Source, XML Source, CSV Source – Provide an option to pass Response Header value to URL
  • NEW: Upsert Destination – Add Support for Azure SQL Data Warehouse
  • NEW: XML Generator Transform, Export XML Task – Give option to Hide Empty Nodes (Self Closing)

Bug fixes

  • FIX: Amazon Storage Task (S3), Azure Storage Task – Advanced Filter doesnt work for Upload Operation (i.e. Where, Sort)
  • FIX: CSV Source – Numbers with plus sign fails component in Preview (e.g. Phone numbers with plus sign prefix)
  • FIX: CSV Source, CSV Parser Transform – You may get error when numbers with comma as decimal separator parsed (Non English systems) – Invalid JavaScript property identifier character: ,. Path ‘total’, line 1, position 125
  • FIX: Download File Task – Automatic Decompression doesn’t happen if web response is compressed (i.e. Accept-Encoding: gzip)
  • FIX: Dummy Data Source – You may get error for DT_IMAGE Type – The given key was not present in the dictionary
  • FIX: Export Excel Task – When you use Template engine, specified target file name is not used (It generates dynamic file name based on last dataset alias)
  • FIX: Export XML Task – UI crashes if you click Convert Attribute right click option (When selected more than one)
  • FIX: General – Deactive option is disabled for License Manager
  • FIX: General – Installer not detecting SQL Server Folder location correctly in some cases
  • FIX: General – License Manager Crash when extra files found in license file folder (ProgramData) – “Object reference not set to an instance of an object” is thrown
  • FIX: Google Data Connection Manager – (Google Analytics) You may get Index was out of range on Generate Token
  • FIX: HTTP Connection Manager – Soap WSS Mode adds duplicate header nodes if self closing Header already found in BODY
  • FIX: HTTP Connection Manager – Soap WSS Mode creates invalid body if POST data contains declare as first line of body
  • FIX: HTTP Connection Manager – Token API being called multiple times in many cases
  • FIX: JSON Generator Transform, XML Generator Transform – You may get error on NULL value if DT_BYTES type used – ERROR – The column has a null value
  • FIX: JSON Source – Example 4 URL not working
  • FIX: JSON Source – When you have blank array as input JSON – You may get error Object reference not set to an instance of an object in Filter selection on UI
  • FIX: JSON Source, XML Source – Complex 2D Transform may throw error – Path returned multiple tokens – When you supply extra columns in manual column list
  • FIX: JSON Source, XML Source – Rfc5988 Pagination – Next Link wont work if you it has single quote rather than double quote (i.e. rel=’next’ )
  • FIX: JSON Source, XML Source – UI doesnt Refresh when you select Local file path
  • FIX: JSON Source, XML Source, CSV Source – Partial Link not supported in RFC5988 Pagination Method
  • FIX: JSON Source, XML Source, JSON Parser Transform, XML Parser Transform – When you select sub document as filter (e.g. $docs[*].info ) rather than array node (e.g. $docs[*] ) it may output NULL values at runtime (preview works)
  • FIX: OAuth Connection Manager – AWS v4 Provider doesnt work for S3 API URL when you have other than us-east-1 region (e.g. https://mybucket.s3-us-west-1.amazonaws.com/somefile.json )
  • FIX: OAuth Connection Manager – Google API Generate Token feature doesn’t work
  • FIX: REST API Task – Spelling error in property name StatusCheckIterationWaitSeconds , StatusCheckMaxWaitSeconds (It was typed as StatucCheckxxxxxxxxxx rather than StatusCheckxxxxxxxxx before)
  • FIX: Upsert Destination – Project level connection is not listed in the connection selection Dropdown on UI
Posted in Announcements.