{"id":6785,"date":"2019-04-18T18:13:16","date_gmt":"2019-04-18T18:13:16","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=6785"},"modified":"2019-04-23T14:06:49","modified_gmt":"2019-04-23T14:06:49","slug":"ssis-powerpack-v2-9-3","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/","title":{"rendered":"SSIS PowerPack v2.9.3 released (Maintenance Release)"},"content":{"rendered":"<h2><span id=\"What8217s_New\">What\u2019s New<\/span><\/h2>\n<p>In this release we focused on mainly providing important BUG fixes \/ features. For example\u00a0in this release we added feature in HTTP Connection to support <a href=\"https:\/\/zappysys.com\/blog\/using-hmac-authentication-api-ssis-odbc-drivers\/\" target=\"_blank\" rel=\"noopener\">HMAC Signature Authentication<\/a>.\u00a0 HMAC Auth enables API support like Azure CosmosDB. We also worked on few bug fixes for <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-salesforce-source-connector\/\" target=\"_blank\" rel=\"noopener\">Salesforce Source<\/a> and <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-redshift-data-transfer-task\/\" target=\"_blank\" rel=\"noopener\">Amazon Redshift Data Transfer Task<\/a>.<\/p>\n<p>Full Notes:\u00a0<a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/release-notes.htm\" target=\"_blank\" rel=\"noopener\">https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/release-notes.htm<\/a><\/p>\n<h2 class=\"vertitle\">Version 2.9.3.10417 [Apr 17, 2019]<\/h2>\n<h3 class=\"versubtitle\">New Features\/Improvements<\/h3>\n<ul>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Amazon Redshift Data Transfer Task &#8211; Add option to save audit information to variables<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Azure Source, AWS Source, Secure FTP Source &#8211; Add support for Zip format (CSV, JSON, XML Sources)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Dynamics CRM Destination &#8211; Add all possible LinkedEntity Type names as comma separated values (Previously only one name was stored)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Add Hash Functions For Placeholders (e.g HASH_SHA1, HASH_SHA256 , HASH_SHA512) &#8211; Use HASH_XXXXXX_HEX to return as Hex value rather than Base64<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>HTTP Connection &#8211; Add Support for <a href=\"https:\/\/zappysys.com\/blog\/using-hmac-authentication-api-ssis-odbc-drivers\/\" target=\"_blank\" rel=\"noopener\">HMAC Signature Authentication<\/a> ( MD5, SHA1, SHA256, SHA512)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON Source, XML Source, CSV Source &#8211; Add support for Zip format when reading data from URL<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Secure FTP Task &#8211; doesn&#8217;t fail when the file we are looking for is not available on the FTP site<\/li>\n<\/ul>\n<h3 class=\"versubtitle\">Bug fixes<\/h3>\n<ul>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon Redshift Data Transfer Task &#8211; Total files loaded count and total lines scanned showing wrong numbers in load summary<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon Redshift Data Transfer Task &#8211; When you check create missing target table option and if its empty you may get &#8211; ERROR: 42P07: Relation &#8220;target_table&#8221; already exists<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon Redshift Data Transfer Task &#8211; When source query produce zero records and you enabled Compressed Gzip files then its never deleted from Stage area regardless Delete Setting<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Dynamics CRM Destination &#8211; You may get error &#8211; Unable to cast object of type &#8216;System.Guid&#8217; to type &#8216;Microsoft.Xrm.Sdk.EntityReference&#8217;<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>HTML Email Task &#8211; EnableSsl Option throws error for some SMTP Servers such as (smtp.office365.com)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JSON Generator Transform, XML Generator Transform, CSV Generator Transform &#8211; Batching doesn&#8217;t work correctly if you place Data flow inside Loop<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JSON Source, XMl Source, CSV Source- You may get Object reference not set error for last page if pagination is set for Rfc5988 Method<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>REST API Task &#8211; Test request from UI may fail if you use HTTP Connection with DynamicToken Setting and Json Filter Expression on Token Response Tab<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Source &#8211; Child Query fields not generated correctly when first row in Query result has zero child records<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Source &#8211; Preview shows wrong data for Child Query fields where child records appear after first row<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Source &#8211; You may receive No records returned for specified table\/query when you try to save UI for Query which returns zero rows (e.g. WHERE condition or HAVING clause usage)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>What\u2019s New In this release we focused on mainly providing important BUG fixes \/ features. For example\u00a0in this release we added feature in HTTP Connection to support HMAC Signature Authentication.\u00a0 HMAC Auth enables API support like Azure CosmosDB. We also worked on few bug fixes for Salesforce Source and Amazon Redshift Data Transfer Task. Full [&hellip;]<\/p>\n","protected":false},"author":1,"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 v2.9.3 released (Maintenance Release) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS PowerPack v2.9.3 released (Maintenance Release) - 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-v2-9-3\/\" \/>\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 v2.9.3 released (Maintenance Release) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS PowerPack v2.9.3 released (Maintenance Release) - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ZappySys\/\" \/>\r\n<meta property=\"article:published_time\" content=\"2019-04-18T18:13:16+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-04-23T14:06:49+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:creator\" content=\"@https:\/\/twitter.com\/zappysys\/\" \/>\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-v2-9-3\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/\",\"name\":\"SSIS PowerPack v2.9.3 released (Maintenance Release) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2019-04-18T18:13:16+00:00\",\"dateModified\":\"2019-04-23T14:06:49+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"SSIS PowerPack v2.9.3 released (Maintenance Release) - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/#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-v2-9-3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS PowerPack v2.9.3 released (Maintenance Release)\"}]},{\"@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\/2756c237457fbc95d82cb38962f81f82\",\"name\":\"ZappySys\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g\",\"caption\":\"ZappySys\"},\"sameAs\":[\"http:\/\/www.zappysys.com\/\",\"https:\/\/www.facebook.com\/ZappySys\/\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/\"],\"url\":\"https:\/\/zappysys.com\/blog\/author\/admin\/\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SSIS PowerPack v2.9.3 released (Maintenance Release) | ZappySys Blog","description":"SSIS PowerPack v2.9.3 released (Maintenance Release) - 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-v2-9-3\/","og_locale":"en_US","og_type":"article","og_title":"SSIS PowerPack v2.9.3 released (Maintenance Release) | ZappySys Blog","og_description":"SSIS PowerPack v2.9.3 released (Maintenance Release) - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2019-04-18T18:13:16+00:00","article_modified_time":"2019-04-23T14:06:49+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_creator":"@https:\/\/twitter.com\/zappysys\/","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-v2-9-3\/","url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/","name":"SSIS PowerPack v2.9.3 released (Maintenance Release) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2019-04-18T18:13:16+00:00","dateModified":"2019-04-23T14:06:49+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"SSIS PowerPack v2.9.3 released (Maintenance Release) - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-3\/#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-v2-9-3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS PowerPack v2.9.3 released (Maintenance Release)"}]},{"@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\/2756c237457fbc95d82cb38962f81f82","name":"ZappySys","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c9be148088ba9b8af8e955c5f7c22b5?s=96&d=mm&r=g","caption":"ZappySys"},"sameAs":["http:\/\/www.zappysys.com\/","https:\/\/www.facebook.com\/ZappySys\/","https:\/\/twitter.com\/https:\/\/twitter.com\/zappysys\/"],"url":"https:\/\/zappysys.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6785"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/comments?post=6785"}],"version-history":[{"count":4,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6785\/revisions"}],"predecessor-version":[{"id":6854,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6785\/revisions\/6854"}],"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=6785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=6785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=6785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}