SSIS PowerPack 5.1.0 released


This was a minor update release. It have added a new API Connectors for HubSpot, OneDrive, SharePoint and JSON Source. It fixes important issues with API Connection Manager, API Connector, Export XML Task, JSON Driver, XML Driver and JSON Source. To see full release notes click here

New Features/Improvements

  • NEW: General – Add Support for Visual Studio 2022 SSIS Designer (VS2022 x64)
  • NEW: API Connection Manager – Sort Connectors by name
  • NEW: API Connector – Google BigQuery – Add Support for Stored Proc / SQL Query which invokes CRUD / DDL / DML Statements (INSERT, UPDATE, DELETE, CREATE, ALTER)
  • NEW: API Connector – Google BigQuery – Performance Enhancements for SQL query / Reduce billing unit per query
  • NEW: API Connector – HubSpot – Added error retry on status code 429
  • NEW: API Connector – OneDrive – Add Retry Option (Handle too Many API Calls – Status 429)
  • NEW: API Connector – OneDrive – Give option to force Login Prompt (e.g. Similar to Clear login cookies)
  • NEW: API Connector – SharePoint – Add Retry Option (Handle too Many API Calls – Status 429)
  • NEW: API Connector – SharePoint – Give option to force Login Prompt (e.g. Similar to Clear login cookies)
  • NEW: API Connector – Zendesk – Search endpoint fails when more than 1000 records returned (Limit of 1000 rows not applied)
  • NEW: API Connector Framework – All Connector Files – Use 429 RetryMode as Property rather than Placeholder
  • NEW: API Connector Framework – Sort Properties by name in Add New Parameter UI (Type=Property)
  • NEW: General – Add support for Turkey (tr-TR) and Azerbaijani (az-Cyrl) environment
  • NEW: JSON Source – Create new connector option should set Version=1 and latest EngineVersion for New Connector file being created during wizard
  • NEW: MongoDB Source – Show user friendly message – How to read View if you see – QueryFailure flag was Namespace 5ddeb5exxxxxx_yourDB.yourViewName is a view, not a collection
  • NEW: PostgreSql Source, Excel Source, Redshift Source, API Source – Add Logging for SQL Query / Table name

Bug fixes

  • FIX: API Connection Manager – Authentication help link doesnt show popup help in some cases
  • FIX: API Connection Manager – Connection Parameter Grid uses old connection to make DataEndPoint calls
  • FIX: API Connection Manager – Embedded Dropdown option for Amazon Ads Connector not working
  • FIX: API Connector – Google BigQuery – You might get duplicate rows in some cases (when query is not cached in BQ)
  • FIX: API Connector Framework – Dynamic Endpoints are expanded on test connection (Usecase: SharePoint Connector uses root site – Causing UnAuthorized Error)
  • FIX: API Connector Framework – Generic_Request EndPoint doesnt work correctly when you supply Body or Headers
  • FIX: API Connector Framework – String value with slash ( \ ) or double quote ( ” ) cause issue in Insert, Update, Delete operations
  • FIX: Export XML Task – UpperCase not allowed in NameSpace Prefix (i.e. nsA=http://xyz) – You get error prefix not declared
  • FIX: General – Placeholder engine doesnt work in some cases when regional settings set to non-english (e.g. Turkish tr-TR)
  • FIX: JSON Driver, XML Driver – When nested filter used (e.g. $.customers[*].orders ) along with IncludeParentColumns option not working sometimes (Throws error or shows wrong value for parent column)
  • FIX: JSON Source – JSONPath expression with $.customers[*].orders can throw error if mixed case detected for array and object for the same property and you check IncludeParentColumns (e.g. orders: [ {…},{…} ] –OR– orders: {…} }
  • FIX: JSON Source – Key Not found exception at runtime when Output as Raw Document Enabled and Include Parent is checked
  • FIX: JSON Source – Pagination with NextUrlFromAttribute and NextLink Cursor does not encode variable placeholder
  • FIX: JSON Source – parent column value not correct when nested array filter used in JSONPath (e.g. $.customers[*].orders[*] ) – This can happen in Raw Output option too
  • FIX: JSON Source – Performance Improvement (when include parent column checked)
Posted in Announcements.