{"id":6641,"date":"2019-03-25T20:00:28","date_gmt":"2019-03-25T20:00:28","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=6641"},"modified":"2019-03-25T20:02:34","modified_gmt":"2019-03-25T20:02:34","slug":"ssis-powerpack-v2-9-2","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/","title":{"rendered":"SSIS PowerPack v2.9.2 released (Maintenance Release)"},"content":{"rendered":"

What’s New<\/h2>\n

In this release we focused on mainly focused on fixing high priority bugs related to Upsert Destination<\/a>. We also added High DPI Monitor Support with Auto Scale UI option (4K Resolution now supported)<\/p>\n

Full Notes: https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/release-notes.htm<\/a><\/p>\n

Version 2.9.2.10321 [Mar 21, 2019]<\/h2>\n

New Features\/Improvements<\/h3>\n
    \n
  • NEW:\u00a0<\/span>Excel Source – Add Option to read first sheet and last sheet rather than fixed name ( $last_sheet$ and $first_sheet$ )<\/li>\n
  • NEW:\u00a0<\/span>General – Support for UI Auto Scaling when High DPI \/ Font Scaling Enabled on your OS (e.g. Win10) – 4K Monitors or High Resolution Display now supported<\/li>\n
  • NEW:\u00a0<\/span>Generator Tarnsforms \/ Export Tasks for JSON, XML, CSV – Add Option to set Date Format at column level rather than global option<\/li>\n
  • NEW:\u00a0<\/span>Upsert Destination – Add Create Table Option based on Upstream Metadata<\/li>\n
  • NEW:\u00a0<\/span>Upsert Destination – Add option to preview exising data from selected table<\/li>\n
  • NEW:\u00a0<\/span>Upsert Destination – Add option to show source and target column datatypes<\/li>\n<\/ul>\n

    Bug fixes<\/h3>\n
      \n
    • FIX:\u00a0<\/span>All Source Components – After Sorting Available Columns you may lose Output column renames in the columns grid, also output columns sorted in reverse order<\/li>\n
    • FIX:\u00a0<\/span>All Source Components – After Sorting Columns you cannot remove or add columns from the grid<\/li>\n
    • FIX:\u00a0<\/span>Upsert Destination – Mapped Column status icon is not refreshing after column is mapped<\/li>\n
    • FIX:\u00a0<\/span>Upsert Destination – varchar, char, text datatypes detected as DT_WSTR \/ DT_NTEXT rather than DT_STR \/ DT_TEXT<\/li>\n
    • FIX:\u00a0<\/span>Upsert Destination – When you have zero rows in source you may get error – Invalid object name #zappysys_xxxxxx_yyyyyyyy<\/li>\n
    • FIX:\u00a0<\/span>Upsert Destination – When you map to column with scale=zero (e.g. numeric(N, 0)) you may get error on save<\/li>\n
    • FIX:\u00a0<\/span>Upsert Destination – You may get error when you change source column after save – An item with the same key has already been added<\/li>\n
    • FIX:\u00a0<\/span>Upsert Destination – You may get object reference not set error in advanced edit<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      What’s New In this release we focused on mainly focused on fixing high priority bugs related to Upsert Destination. We also added High DPI Monitor Support with Auto Scale UI option (4K Resolution now supported) Full Notes: https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/release-notes.htm Version 2.9.2.10321 [Mar 21, 2019] New Features\/Improvements NEW:\u00a0Excel Source – Add Option to read first sheet and […]<\/p>\n","protected":false},"author":1,"featured_media":16,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[442,472,444],"tags":[21,83],"yoast_head":"\r\nSSIS PowerPack v2.9.2 released (Maintenance Release) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS PowerPack v2.9.2 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-2\/\" \/>\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.2 released (Maintenance Release) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS PowerPack v2.9.2 released (Maintenance Release) - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/\" \/>\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-03-25T20:00:28+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-03-25T20:02:34+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-2\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/\",\"name\":\"SSIS PowerPack v2.9.2 released (Maintenance Release) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2019-03-25T20:00:28+00:00\",\"dateModified\":\"2019-03-25T20:02:34+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"SSIS PowerPack v2.9.2 released (Maintenance Release) - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/#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-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS PowerPack v2.9.2 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.2 released (Maintenance Release) | ZappySys Blog","description":"SSIS PowerPack v2.9.2 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-2\/","og_locale":"en_US","og_type":"article","og_title":"SSIS PowerPack v2.9.2 released (Maintenance Release) | ZappySys Blog","og_description":"SSIS PowerPack v2.9.2 released (Maintenance Release) - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2019-03-25T20:00:28+00:00","article_modified_time":"2019-03-25T20:02:34+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-2\/","url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/","name":"SSIS PowerPack v2.9.2 released (Maintenance Release) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2019-03-25T20:00:28+00:00","dateModified":"2019-03-25T20:02:34+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"SSIS PowerPack v2.9.2 released (Maintenance Release) - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-v2-9-2\/#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-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS PowerPack v2.9.2 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\/6641"}],"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=6641"}],"version-history":[{"count":1,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6641\/revisions"}],"predecessor-version":[{"id":6642,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6641\/revisions\/6642"}],"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=6641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=6641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=6641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}