Contents
hide
New Features/Improvements
- NEW: Amazon SQS Source – Add columns for SequenceNumber, MessageGroupId and MessageDeduplicationId
- NEW: Amazon SQS Source, Azure Queue Source – Add option MaxRetryOnNullMessage to retry for N times before stop reading from queue
- NEW: Dummy Data Source – Add Random GUID support for DT_GUID type
- NEW: General – Add option to Import / Export Columns Mapping Grid for Source / Transform Components (e.g. JSON, CSV, XML …)
- NEW: Installer – Remove .net Framework 3.5 dependency requirement from installer (3.5 Framework was required for only SSIS 2008 which is now depreciated)
- NEW: JSON Source, JSON Parser Transform- Add option (EnableBigNumberHandling) to support for parsing very large number as string rather than throwing error
- NEW: JSON, XML CSV Source / Parser Transform – Provide a way to output Binary data from Base64 String when DT_BYTES, DT_IMAGE datatype is used for String Fields
- NEW: OAuth Connection Manager – Provide UI for Custom Auth Header / Scheme (i.e. Authorization : Bearer xxxxxxxx)
Bug fixes
- FIX: Azure Blob CSV Destination – You may get error – System.InvalidCastException: Specified cast is not valid
- FIX: Azure Storage CSV File Destination – APPEND Option is not working
- FIX: Google Analytics Source – You may get Profile not specified error when you combine multiple nodes (e.g. accounts, profiles) – Its using AND condition rather than OR
- FIX: Google Data Connection Manager – Once you start token extract using default browser and click Cancel Button it launches browser again
- FIX: Installer – You may get message SQL Server Integration Services was not detected
- FIX: JSON Source, JSON Parser Transform – Document with very large number may produce duplicate data
- FIX: Logging Task – Use of Mixed Placeholders Static (i.e. << .. >>) and Variable ( i.e. {{ … }} ) cause runtime error (works fine in Design time Preview)
- FIX: PostgreSql Connection Manager – You may get error Object does not match target type when you build or save project
- FIX: REST API Task – UrlFromVariable Mode at Design time Test request feature uses DirectUrl rather than Variable Value (At run time it works fine)
- FIX: Secure FTP CSV File Destination – APPEND Option is not working
- FIX: XML File Destination / Generator / Export Task – Output as CData option is not working