{"id":9391,"date":"2021-09-28T15:08:35","date_gmt":"2021-09-28T15:08:35","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9391"},"modified":"2021-09-28T15:08:35","modified_gmt":"2021-09-28T15:08:35","slug":"ssis-powerpack-4-1-1-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/","title":{"rendered":"SSIS PowerPack 4.1.1 released"},"content":{"rendered":"<h3 class=\"versubtitle\">Introduction<\/h3>\n<p>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 <a href=\"https:\/\/zappysys.com\/api\/integration-hub\">popular API services<\/a>. We also added many new features\u00a0 in various tasks \/ components along with bug fixes \/ performance improvement features.<\/p>\n<p>To see full release notes <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/release-notes.htm\" target=\"_blank\" rel=\"noopener\">click here<\/a><\/p>\n<h3 class=\"versubtitle\">New Features\/Improvements<\/h3>\n<ul>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector &#8211; Sharepoint Online &#8211; Read\/write List data, Download Files, Upload Files<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector Engine &#8211; Add an option to replace Dynamic Expand Table parameters<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector Engine &#8211; Allow to detect datatypes from property name<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Source &#8211; Show Tables in the list (Select Operation)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Source, API Destination &#8211; Parallel execution can cause Key already added exception<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Add FUN_TRIM_QUOTE placeholder function<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>HTTP Connection Manager &#8211; Add new timestamp format unix-epoch-ms (or just epoch-ms) to return UNIX Timestamp in milliseconds format in HASH \/ HMACH Authentication Type<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>HTTP Connection Manager &#8211; Allow [$body$] placeholder in String to Sign in HMAC \/ HASH Authentication Type<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>OAuth Connection Manager &#8211; Add Google Sheets, Google BigQuery Provider<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>OAuth Connection Manager &#8211; Add Support for Google Service Account (using p12 file)<\/li>\n<\/ul>\n<h3 class=\"versubtitle\">Bug fixes<\/h3>\n<ul>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon S3 JSON, XML, CSV File Source Task &#8211; Connection dropdown overlapping with Label<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Connection Manager &#8211; Test Connection fails to use new Token<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Connector Engine &#8211; Connection level parameter value not used by EndPoint when same parameter defined without value<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Connector Engine &#8211; Loading Blank Label for Expand Column can set blank name for column<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Connector Engine &#8211; Multi Select Parameter is not correctly decoded when Value is read<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Source, API Destination &#8211; UI Validation doesnt happen for destination, For Source throws error about required parameter even though some value supplied either in connection parameters \/ other overrides<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>HTTP Connection Manager &#8211; When your body is coming from File and you have used [$body-hash-xxxxxx$] placeholder in HMAC \/ HASH Authentication it doesnt work<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction 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\u00a0 in various tasks \/ components along with bug fixes \/ performance improvement features. To see full release notes [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":16,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[442],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS PowerPack 4.1.1 released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS PowerPack 4.1.1 released - ZappySys Blog\" \/>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"SSIS PowerPack 4.1.1 released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS PowerPack 4.1.1 released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2021-09-28T15:08:35+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"77\" \/>\r\n\t<meta property=\"og:image:height\" content=\"70\" \/>\r\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\r\n<meta name=\"author\" content=\"ZappySys\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ZappySys\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/\",\"name\":\"SSIS PowerPack 4.1.1 released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2021-09-28T15:08:35+00:00\",\"dateModified\":\"2021-09-28T15:08:35+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\"},\"description\":\"SSIS PowerPack 4.1.1 released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"width\":77,\"height\":70,\"caption\":\"ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS PowerPack 4.1.1 released\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/zappysys.com\/blog\/#website\",\"url\":\"https:\/\/zappysys.com\/blog\/\",\"name\":\"ZappySys Blog\",\"description\":\"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/zappysys.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"url\":\"https:\/\/zappysys.com\/blog\/author\/hshah\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS PowerPack 4.1.1 released | ZappySys Blog","description":"SSIS PowerPack 4.1.1 released - ZappySys Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/","og_locale":"en_US","og_type":"article","og_title":"SSIS PowerPack 4.1.1 released | ZappySys Blog","og_description":"SSIS PowerPack 4.1.1 released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/","og_site_name":"ZappySys Blog","article_published_time":"2021-09-28T15:08:35+00:00","og_image":[{"width":77,"height":70,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/","url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/","name":"SSIS PowerPack 4.1.1 released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2021-09-28T15:08:35+00:00","dateModified":"2021-09-28T15:08:35+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35"},"description":"SSIS PowerPack 4.1.1 released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","width":77,"height":70,"caption":"ZappySys Logo - SSIS, SQL Server, Big Data, Cloud Computing, NoSQL, Business Intelligence"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-1-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS PowerPack 4.1.1 released"}]},{"@type":"WebSite","@id":"https:\/\/zappysys.com\/blog\/#website","url":"https:\/\/zappysys.com\/blog\/","name":"ZappySys Blog","description":"SSIS \/ ODBC Drivers \/ API Connectors for JSON, XML, Azure, Amazon AWS, Salesforce, MongoDB and more","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/zappysys.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/076a738938c19d459fbfe125c759a0ea?s=96&d=mm&r=g","caption":"ZappySys"},"url":"https:\/\/zappysys.com\/blog\/author\/hshah\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9391"}],"collection":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=9391"}],"version-history":[{"count":1,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9391\/revisions"}],"predecessor-version":[{"id":9393,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9391\/revisions\/9393"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/16"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=9391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=9391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=9391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}