{"id":8872,"date":"2020-04-28T17:10:07","date_gmt":"2020-04-28T17:10:07","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=8872"},"modified":"2020-04-28T17:10:07","modified_gmt":"2020-04-28T17:10:07","slug":"ssis-powerpack-v3-1-1-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/","title":{"rendered":"SSIS PowerPack v3.1.1 released"},"content":{"rendered":"<h3 class=\"versubtitle\">New Features\/Improvements<\/h3>\n<ul>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Amazon Storage Task, Azure Storage Task, Secure FTP Storage Task, Advanced File System Task &#8211; Add option to get latest \/oldest file path from specified folder or pattern search<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Add Placeholder Function FUN_TIMESTAMP_UNIX to return Unix Style Timestamp of current UTC DateTime (i.e. epoch) (Usage 1325394000 or 1587560359 for Current time)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Give option to pass content-type for multi-part upload request (Right now its guessed from file extension)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Retry registration of license key of you get timeout or other connection issue due to network failure<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Trial License shows incorrect License Issue date (Should be the day it got created)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; You may get misleading error message (Illegal characters in path) when you save UI and it tries to generate metadata (It should say something like file(s) not found for the given pattern)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Google Data Connection Manager &#8211; Add support for retain connection (Option available in Property Grid Only)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>HTTP Connection Manager &#8211; Add Support for HashTreatApiKeyAsNonBase64, HashSignWithApiKey (Usecase: Some API like nativo use ApiKey rather Secret to Generate HMAC Hash)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>HTTP Connection Manager &#8211; Add support for retain connection (Option available in Property Grid Only)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON, XML, CSV Source &#8211; Scan multiple files to generate metadata<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON, XML, CSV Source &#8211; Show sample records from multiple files when wildcard pattern is used<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>OAuth Connection Manager &#8211; Add support for retain connection (Option available in Property Grid Only)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Upsert Destination &#8211; For Fast Performance &#8211; Detect Index on the target table based on selected key column and if index is missing then warn user and provide a way to create one<\/li>\n<\/ul>\n<h3 class=\"versubtitle\">Bug fixes<\/h3>\n<ul>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>AWS, Azure, SFTP Source for JSON, CSV and XML &#8211; When you enter DirectPath start with slash and ending with pattern &#8211; You may get misleading error &#8211; GetStream does not support pattern in file path<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Azure Storage Task &#8211; Create New Variable may not default to correct type on certain operations (e.g. get file exists status &#8211; bool)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>General &#8211; TypeConverters not set correctly for Data Flow Components so DropDowns not provided in Property Grid for SSIS 2014, 2016, 2017 and 2019 Packages<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JSON Source, CSV Source, XML Source &#8211; When you have empty DT_DBDATE or DT_DATE type you may get error &#8211; String was not recognized as a valid DateTime<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JSON, XML Generator, Destination, Export Task &#8211; Treat value as Fragment checkbox is not loaded when you edit Element after saving UI<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Redshift Connection Manager &#8211; Default port should be 5439 rather than 5432<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Source &#8211; For certain tables You may get error error &#8211; &#8216;tns:XXXXXXXXX&#8217; is not a valid value for soapType &#8211;OR&#8211; &#8216;urn:XXXXXXXXX&#8217; is not a valid value for soapType<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Upsert Destination &#8211; Always Quote around objects in the Table list this way some objects with reserved keywords (e.g. dbo.Case ) doesnt throw errors like (Incorrect Syntax near keyword &#8216;Somename&#8217; )<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Upsert Destination &#8211; Does not handle data well for columns with IDENTITY option (Honor IsIdentity setting found on Advanced Editor &#8211; Input \/ Output Columns &#8211; External Columns)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Upsert Destination &#8211; For PostgreSql \/ Redshift Target if you use custom Staging Table &#8211; You might get error ERROR: relation &#8220;xxxxxxx&#8221; does not exist (Error occurs when you use Table name without quoted identifiers e.g. &#8220;public&#8221;.&#8221;stagingtable&#8221;)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Upsert Destination &#8211; Preview data doesn&#8217;t work if you use Variable in Table name (e.g {{User::MyTableName}} )<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>XML Source, XML Parser &#8211; When filter doesnt end with [*] and you use Key\/Value &#8211; 2D Transform &#8211; You might get error &#8211; Object reference not set&#8221;<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>XML Source, XML Parser &#8211; When you uncheck Include Parent Columns option and filter doesnt end with [*] and you use Key\/Value &#8211; 2D Transform &#8211; You might not get any data<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>XML Source, XML Parser Transform &#8211; Key\/Value 2D Transform Filter is invalid after Browse action (it adds [*] after $.)<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>New Features\/Improvements NEW:\u00a0Amazon Storage Task, Azure Storage Task, Secure FTP Storage Task, Advanced File System Task &#8211; Add option to get latest \/oldest file path from specified folder or pattern search NEW:\u00a0General &#8211; Add Placeholder Function FUN_TIMESTAMP_UNIX to return Unix Style Timestamp of current UTC DateTime (i.e. epoch) (Usage 1325394000 or 1587560359 for Current time) [&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 v3.1.1 released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS PowerPack v3.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-v3-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 v3.1.1 released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS PowerPack v3.1.1 released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/\" \/>\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=\"2020-04-28T17:10:07+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=\"3 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-v3-1-1-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/\",\"name\":\"SSIS PowerPack v3.1.1 released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2020-04-28T17:10:07+00:00\",\"dateModified\":\"2020-04-28T17:10:07+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"SSIS PowerPack v3.1.1 released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-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-v3-1-1-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS PowerPack v3.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\/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 v3.1.1 released | ZappySys Blog","description":"SSIS PowerPack v3.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-v3-1-1-released\/","og_locale":"en_US","og_type":"article","og_title":"SSIS PowerPack v3.1.1 released | ZappySys Blog","og_description":"SSIS PowerPack v3.1.1 released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2020-04-28T17:10:07+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/","url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/","name":"SSIS PowerPack v3.1.1 released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2020-04-28T17:10:07+00:00","dateModified":"2020-04-28T17:10:07+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"SSIS PowerPack v3.1.1 released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-1-1-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v3-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-v3-1-1-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS PowerPack v3.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\/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\/8872"}],"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=8872"}],"version-history":[{"count":1,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8872\/revisions"}],"predecessor-version":[{"id":8873,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8872\/revisions\/8873"}],"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=8872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=8872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=8872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}