SSIS PowerPack 4.1.1 released


We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features  in various tasks / components along with bug fixes / performance improvement features.

To see full release notes click here

New Features/Improvements

  • NEW: API Connector – Sharepoint Online – Read/write List data, Download Files, Upload Files
  • NEW: API Connector Engine – Add an option to replace Dynamic Expand Table parameters
  • NEW: API Connector Engine – Allow to detect datatypes from property name
  • NEW: API Source – Show Tables in the list (Select Operation)
  • NEW: API Source, API Destination – Parallel execution can cause Key already added exception
  • NEW: General – Add FUN_TRIM_QUOTE placeholder function
  • NEW: HTTP Connection Manager – Add new timestamp format unix-epoch-ms (or just epoch-ms) to return UNIX Timestamp in milliseconds format in HASH / HMACH Authentication Type
  • NEW: HTTP Connection Manager – Allow [$body$] placeholder in String to Sign in HMAC / HASH Authentication Type
  • NEW: OAuth Connection Manager – Add Google Sheets, Google BigQuery Provider
  • NEW: OAuth Connection Manager – Add Support for Google Service Account (using p12 file)

Bug fixes

  • FIX: Amazon S3 JSON, XML, CSV File Source Task – Connection dropdown overlapping with Label
  • FIX: API Connection Manager – Test Connection fails to use new Token
  • FIX: API Connector Engine – Connection level parameter value not used by EndPoint when same parameter defined without value
  • FIX: API Connector Engine – Loading Blank Label for Expand Column can set blank name for column
  • FIX: API Connector Engine – Multi Select Parameter is not correctly decoded when Value is read
  • FIX: API Source, API Destination – UI Validation doesnt happen for destination, For Source throws error about required parameter even though some value supplied either in connection parameters / other overrides
  • FIX: HTTP Connection Manager – When your body is coming from File and you have used [$body-hash-xxxxxx$] placeholder in HMAC / HASH Authentication it doesnt work
Posted in Announcements.