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