{"id":8958,"date":"2020-06-03T21:13:25","date_gmt":"2020-06-03T21:13:25","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=8958"},"modified":"2020-06-03T21:13:25","modified_gmt":"2020-06-03T21:13:25","slug":"ssis-powerpack-3-1-3-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/","title":{"rendered":"SSIS PowerPack 3.1.3 released"},"content":{"rendered":"<h3 class=\"versubtitle\">New Features\/Improvements<\/h3>\n<ul>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>HTTP Connection Manager &#8211; Allow option to set DynamicToken request as Form-Data (Multi-Part) request<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>HTTP Connection Manager &#8211; For Dynamic Token option when Auth Scheme contains space do not suffix another space (e.g. MyAuthScheme sess-id=)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON Source &#8211; Allow to set Custom Filter for Column Less 2D Array with First Line as Column Names on 2D Transform Tab (Google Sheet API scenario to treat First Line as Column Names)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON Source, XML Source, CSV Source &#8211; Add Some Advanced Pagination Properties On UI<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON Source, XML Source, CSV Source &#8211; Give option to paginate using POST &#8211; startIndex, endIndex Pattern (Currently we have only via URL)<\/li>\n<\/ul>\n<h3 class=\"versubtitle\">Bug fixes<\/h3>\n<ul>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon S3 CSV Destination &#8211; Split By Row Count setting causes duplicate data when DisableMultiPart option is False (Happens when File Size is greater than 5 MB)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon S3 Storage Task &#8211; Get Amazon Folder List option fetching subfolders too when Recursive option is not checked<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon S3 Storage Task, Azure Blob Storage Task &#8211; Sync Operation doesn&#8217;t work if your Source Folder is Network Share (e.g. \\\\sharename\\folder )<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon S3, Azure Blob Storage Task, Source (CSV, XML, JSON) &#8211; If you use wild card pattern search without Recursive option it may take very long time if sub folder contains many files (It tries to scan sub folders under that path too which slows down)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Azure Blob, Amazon S3 Storage Task, Amazon S3 Source (CSV, XML, JSON) &#8211; Browse Path takes long time to load OR it might crash if you have many files stored in the selected bucket<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>CSV File Destination for Azure, Amazon S3, SFTP &#8211; Split by Size Mode is not working in most of the Destination components<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Dynamics CRM Destination &#8211; Lookup Type fields are treated as OwnerId update in Older CRM version &#8211; You may get error &#8211; Unsupported entity type while converting to security principal<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Export CSV File Task &#8211; DateTimeOffset data type is not exported correctly when you use ADO.net connection type for source<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>General &#8211; Semicolon not allowed for any value inside Connection Manager (E.g. Password or UserName connot contain &#8220;;&#8221;)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>OAuth Connection Manager &#8211; AWS v4 Provider doesnt support File Upload Request (i.e. Supplying File Path in Body using Is MultiPart checkbox) &#8211; You get The provided &#8216;x-amz-content-sha256&#8217; header does not match what was computed.<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>OAuth Connection Manager &#8211; DropBox Provider is not working (Its using depreciated API URL)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>PostgreSql Source, PostgreSql Destination &#8211; Add support for bytea datatype (Byte Array \/ Binary Type)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Redshift Data Transfer Task &#8211; Create Missing Table option doesnt create correct types (including nvarchar(max) of SQL Server))<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Upsert Destination &#8211; If your SQL database is set to Case Sensitive Collation (e.g. Latin1_General_BIN or Turkish_CI_AS) you may get Invalid object name &#8216;information_schema.key_column_usage&#8217; error on table name selection on UI<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>XML Source, XML Parser &#8211; In certain case when you choose Value array in Filter &#8211; You may get error &#8211; An item with the same key has already been added<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>New Features\/Improvements NEW:\u00a0HTTP Connection Manager &#8211; Allow option to set DynamicToken request as Form-Data (Multi-Part) request NEW:\u00a0HTTP Connection Manager &#8211; For Dynamic Token option when Auth Scheme contains space do not suffix another space (e.g. MyAuthScheme sess-id=) NEW:\u00a0JSON Source &#8211; Allow to set Custom Filter for Column Less 2D Array with First Line as Column [&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 3.1.3 released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS PowerPack 3.1.3 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-3-1-3-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 3.1.3 released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS PowerPack 3.1.3 released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-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-06-03T21:13:25+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-3-1-3-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/\",\"name\":\"SSIS PowerPack 3.1.3 released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2020-06-03T21:13:25+00:00\",\"dateModified\":\"2020-06-03T21:13:25+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"SSIS PowerPack 3.1.3 released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-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-3-1-3-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS PowerPack 3.1.3 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 3.1.3 released | ZappySys Blog","description":"SSIS PowerPack 3.1.3 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-3-1-3-released\/","og_locale":"en_US","og_type":"article","og_title":"SSIS PowerPack 3.1.3 released | ZappySys Blog","og_description":"SSIS PowerPack 3.1.3 released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2020-06-03T21:13:25+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-3-1-3-released\/","url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/","name":"SSIS PowerPack 3.1.3 released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2020-06-03T21:13:25+00:00","dateModified":"2020-06-03T21:13:25+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"SSIS PowerPack 3.1.3 released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-3-1-3-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-3-1-3-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS PowerPack 3.1.3 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\/8958"}],"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=8958"}],"version-history":[{"count":1,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8958\/revisions"}],"predecessor-version":[{"id":8959,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/8958\/revisions\/8959"}],"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=8958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=8958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=8958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}