SSIS PowerPack 4.0.0 released

Introduction

This is a Major build with some significant features and important bug fixes. Most important addition in this release is brand new API Connector Framework. We introduced brand new components API Source and API Destination to read / write API data without learning internals about API call (i.e. Authentication, Pagination). Previously this was achieved using generic JSON , XML, CSV Source and Web API destination but many users felt it was too complex to learn internals of API and it required learning curve.

With new API Connector Framework now its possible to consume API data in few clicks.

New Features/Improvements

  • NEW: API Connector – New connector for Amazon MWS (Used with API Source, API Destination)
  • NEW: API Connector – New connector for Google BigQuery (Used with API Source, API Destination)
  • NEW: API Connector – New connector for Google Sheets (Used with API Source, API Destination)
  • NEW: API Connector – New connector for OData (Used with API Source, API Destination)
  • NEW: API Connector – New connector for Zendesk (Used with API Source, API Destination)
  • NEW: API Connector – New connector for Zoho CRM (Used with API Source, API Destination)
  • NEW: API Connector Framework – Highly Extensible Framework to build your own API Connectors which can be used inside SSIS API Source / Destination or other apps (e.g. Power BI, Excel, Informatica) using ZappySys API ODBC Driver (See https://zappysys.com/api )
  • NEW: API Destination – NEW Component: Allows to write (insert, update, delete, lookup) data to popular API services using pre-configured Connector Files (Created using API Connector Framework – See https://zappysys.com/api )
  • NEW: API Source – NEW Component: Allows to read data from popular API services using pre-configured Connector Files (Created using API Connector Framework – See https://zappysys.com/api )
  • NEW: Export CSV Task, Export JSON Task – Add option AllowHeaderRowAppendForNonEmptyFile to allow Header row Append for non empty files
  • NEW: Export CSV Task, Export JSON Task – Add option for Document level custom Header / Footer text
  • NEW: General – License Key activation might fail if you have new line character in key
  • NEW: General – Long Variable names are sometimes not visible fully in selection dropdowns
  • NEW: General – New Placeholder function for date time variable {{User::MyDate, yyyy-MM-dd || today+7day}} (Function Syntax: [Now, Today, Yesterday, Weekstart, Weekend, MonthStart, MonthEnd, YearStart, YearEnd] [+/- [N] [d, m, y, h, min, s, ms]]
  • NEW: General – New Placeholder function TO_DATE e.g. <<today+5d,FUN_TO_DATE>> OR mixed case <<-5d||yyyy-MM-dd||{{User::dt}},FUN_TO_DATE>> (Function Syntax: [Now, Today, Yesterday, Weekstart, Weekend, MonthStart, MonthEnd, YearStart, YearEnd] [+/- [N] [d, m, y, h, min, s, ms]]
  • NEW: HTML Table Source – Add option to specify custom Character Set
  • NEW: HTTP Connection Manager – Add option to set custom SslVersion (Windows 2012R2 usecase with DynamicToken)
  • NEW: JSON / XML / CSV Source, REST API Task – Setting blank value for If-Modified-Since header throws error
  • NEW: Json Source, XML Source – In URL parameter / URL path Pagination mode support Stop pattern based on URL Response Attribute Value (i.e. stop when HasMore = false )
  • NEW: OAuth Connection Manager – To handle IE11 correctly – Provide a way to disable token auto extract in Default Browser flow (Enter –no-extract in Refresh token Field before clicking Generate Token)
  • NEW: PostgreSql Connection Manager – (SSIS 2014 and higher) Add support for password HASH authentication (SCRAM-SHA-256) for Postgresql 10 or higher – Fix Error : Only AuthenticationClearTextPassword and AuthenticationMD5Password supported: Received 10
  • NEW: REST API Task – Provide an option to Fail Task if Expression not match , By default all must return blank on no match (JSONPath / XMLPath not doing it right now)
  • NEW: REST API Task – URL Textbox doesnt show preview without placeholder option on edit
  • NEW: Salesforce Destination – Add support for Bulk API V2 (Better Lock Handling)
  • NEW: Salesforce Destination – Improve performance in BulkApi mode by compressing Body
  • NEW: Secure FTP Connection – Update Core SFTP Dlls to use Framework 4.0
  • NEW: Secure FTP Task, Amazon Storage Task, Azure Blob Storage Task – Give Option to treat Regex for full path vs file name

Bug fixes

  • FIX: Advanced File System, Secure FTP, Amazon Storage, Azure Storage Task – Create new file action with blank content text throws validation error – Path is not specified
  • FIX: All Components – If Error Output is not attached down stream and mode is set to RedirectRow on error then you might get “Unspecified error” at runtime
  • FIX: Amazon S3 Storage Task, Azure Blob Storage Task – Copy / Move Operation truncates file name if file name has colon ( : ) or other special characters
  • FIX: CSV Source – Parser might output new line character in some cases for last column in certain row
  • FIX: CSV Source, CSV Parse Transform – DateParse Option with Custom Date Format doesnt work
  • FIX: Export CSV Task – Row Delimiter doesn’t retain custom value
  • FIX: Export JSON Task, Export XML Task – Editing a Field Mapping throws error if source sql has a variable in it (i.e. {{User::MyVar}} )
  • FIX: Google Analytics Source, OAuth Connection Manager – When IE11 is default browser it fails to extract token automatically with Invalid_grant error – This issue can also occur with other OAuth API
  • FIX: JSON Source, XML Source – Key/Value Pivot Transform returns NULL at runtime if Value is nested object with multiple properties
  • FIX: Json Source, XML Source – Pagination doesnt stop in ByResponseAttribute mode when last page is blank (i.e. [ ] )
  • FIX: JSON Source, XML Source, REST API Task – Continue On Error String option not working (It doesn’t throw error if match not found)
  • FIX: OAuth Connection Manager – Google Provider fails to auto extract token using default flow
  • FIX: PostgreSql Source, PostgreSql Destination – XML, JSON, UUID Datatype detected as wrong SSIS type (i.e. generates DT_WSTR with -1 length)
  • FIX: Salesforce Destination – On certain error (e.g. Bad table name) execution crash without proper error message
  • FIX: Secure FTP Connection – Large data transfer might fails on FIPS enabled machine (Fx 4.0 dll issue)
  • FIX: Secure FTP Connection – When Download fails sometimes it creates partial file (Fx 4.0 dll Issue)
  • FIX: Secure FTP Task – If transfer fails half way file is not deleted
  • FIX: PostgreSQL Connection – For some servers your connection might failed with error – SSPI failed error
  • FIX: Upsert Destination – You might get error during index creation on UI save if key column contains dash (Error: Incorrect syntax near ‘-‘. )
  • FIX: XML Generator Task – XML is truncated if DoNotOutputEmptyNestedAttribute property is TRUE
Posted in Announcements.