SSIS PowerPack v3.1.1 released

New Features/Improvements

  • NEW: Amazon Storage Task, Azure Storage Task, Secure FTP Storage Task, Advanced File System Task – Add option to get latest /oldest file path from specified folder or pattern search
  • NEW: General – Add Placeholder Function FUN_TIMESTAMP_UNIX to return Unix Style Timestamp of current UTC DateTime (i.e. epoch) (Usage 1325394000 or 1587560359 for Current time)
  • NEW: General – Give option to pass content-type for multi-part upload request (Right now its guessed from file extension)
  • NEW: General – Retry registration of license key of you get timeout or other connection issue due to network failure
  • NEW: General – Trial License shows incorrect License Issue date (Should be the day it got created)
  • NEW: General – You may get misleading error message (Illegal characters in path) when you save UI and it tries to generate metadata (It should say something like file(s) not found for the given pattern)
  • NEW: Google Data Connection Manager – Add support for retain connection (Option available in Property Grid Only)
  • NEW: HTTP Connection Manager – Add Support for HashTreatApiKeyAsNonBase64, HashSignWithApiKey (Usecase: Some API like nativo use ApiKey rather Secret to Generate HMAC Hash)
  • NEW: HTTP Connection Manager – Add support for retain connection (Option available in Property Grid Only)
  • NEW: JSON, XML, CSV Source – Scan multiple files to generate metadata
  • NEW: JSON, XML, CSV Source – Show sample records from multiple files when wildcard pattern is used
  • NEW: OAuth Connection Manager – Add support for retain connection (Option available in Property Grid Only)
  • NEW: Upsert Destination – For Fast Performance – Detect Index on the target table based on selected key column and if index is missing then warn user and provide a way to create one

Bug fixes

  • FIX: AWS, Azure, SFTP Source for JSON, CSV and XML – When you enter DirectPath start with slash and ending with pattern – You may get misleading error – GetStream does not support pattern in file path
  • FIX: Azure Storage Task – Create New Variable may not default to correct type on certain operations (e.g. get file exists status – bool)
  • FIX: General – TypeConverters not set correctly for Data Flow Components so DropDowns not provided in Property Grid for SSIS 2014, 2016, 2017 and 2019 Packages
  • FIX: JSON Source, CSV Source, XML Source – When you have empty DT_DBDATE or DT_DATE type you may get error – String was not recognized as a valid DateTime
  • FIX: JSON, XML Generator, Destination, Export Task – Treat value as Fragment checkbox is not loaded when you edit Element after saving UI
  • FIX: Redshift Connection Manager – Default port should be 5439 rather than 5432
  • FIX: Salesforce Source – For certain tables You may get error error – ‘tns:XXXXXXXXX’ is not a valid value for soapType –OR– ‘urn:XXXXXXXXX’ is not a valid value for soapType
  • FIX: Upsert Destination – Always Quote around objects in the Table list this way some objects with reserved keywords (e.g. dbo.Case ) doesnt throw errors like (Incorrect Syntax near keyword ‘Somename’ )
  • FIX: Upsert Destination – Does not handle data well for columns with IDENTITY option (Honor IsIdentity setting found on Advanced Editor – Input / Output Columns – External Columns)
  • FIX: Upsert Destination – For PostgreSql / Redshift Target if you use custom Staging Table – You might get error ERROR: relation “xxxxxxx” does not exist (Error occurs when you use Table name without quoted identifiers e.g. “public”.”stagingtable”)
  • FIX: Upsert Destination – Preview data doesn’t work if you use Variable in Table name (e.g {{User::MyTableName}} )
  • FIX: XML Source, XML Parser – When filter doesnt end with [*] and you use Key/Value – 2D Transform – You might get error – Object reference not set”
  • FIX: XML Source, XML Parser – When you uncheck Include Parent Columns option and filter doesnt end with [*] and you use Key/Value – 2D Transform – You might not get any data
  • FIX: XML Source, XML Parser Transform – Key/Value 2D Transform Filter is invalid after Browse action (it adds [*] after $.)
Posted in Announcements.