{"id":10147,"date":"2023-08-02T10:48:47","date_gmt":"2023-08-02T10:48:47","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=10147"},"modified":"2023-08-02T13:56:43","modified_gmt":"2023-08-02T13:56:43","slug":"ssis-powerpack-5-0-0-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/","title":{"rendered":"SSIS PowerPack 5.0.0 released"},"content":{"rendered":"

Introduction<\/span><\/h3>\n

This release brings tons of new features and bug fixes. We have added new connectors for Youtube, Stripe, Zoom, Amazon Ads and ManageEngine. It fixes important issues with MongoDB Source, Amazon DynamoDB Source, Azure Table Source, XML Generator Transform. To see full release notes\u00a0click here<\/a><\/p>\n

New Features\/Improvements<\/h3>\n
    \n
  • NEW: <\/span>General – Add support for SQL Server 2022<\/li>\n
  • NEW: <\/span>API Connector – Youtube – New connector to read, search Videos \/ Playlists and other information (like, view, share, title, watch time etc)<\/li>\n
  • NEW: <\/span>API Connector – Stripe – New connector to read \/ write Customers, Orders, Invoices, Products, Subscriptions and more<\/li>\n
  • NEW: <\/span>API Connector – Zoom – New connector to read Meetings, Webinars, Attendees and other information from Zoom Service<\/li>\n
  • NEW: <\/span>API Connector – Amazon Ads – New connector to read reports for Amazon Ads Account<\/li>\n
  • NEW: <\/span>API Connector – ManageEngine ServiceDesk Plus- New Connector to read data from Requests, Tasks, Notes, Worklog and more<\/li>\n
  • NEW: <\/span>Advanced File System Task – Add Support for {%name_before_dot%}, {%filenum%}, {%totalfiles%}, {%timestamp%} placeholders<\/li>\n
  • NEW: <\/span>API Connector – Google BigQuery – Add retry on 429 status code (currently its only on 403)<\/li>\n
  • NEW: <\/span>API Connector – Google Calendar – Add retry on 429 status code (currently its only on 403)<\/li>\n
  • NEW: <\/span>API Connector – Google Drive – Add retry on 429 status code (currently its only on 403)<\/li>\n
  • NEW: <\/span>API Connector – Google Sheets – Add retry on 429 status code (currently its only on 403)<\/li>\n
  • NEW: <\/span>API Connector – HubSpot – Add support for PrivateApp Authentication (Using Static Access Token)<\/li>\n
  • NEW: <\/span>API Connector – SharePoint – Added support for Lookup fields and added <FieldName>LookupId columns (numeric id) to know referenced row. Also added expand parameter with selection to expand selected fields only<\/li>\n
  • NEW: <\/span>API Connector – Zendesk – Add support for comment on existing ticket \/ added support for HTML Comment<\/li>\n
  • NEW: <\/span>API Connector Framework – Provide an option MultiSelectAllOnDefault – If default value supplied for parameter then invoke Select All <\/li>\n
  • NEW: <\/span>API Connector Framework – Provide LayoutMap and {$rows$} for ChildEndPoint (Useful to pass parent URL ids in Batch to child URL)<\/li>\n
  • NEW: <\/span>General – Show better message when Trial Registration failed in ADF due to Firewall blocking license service call<\/li>\n
  • NEW: <\/span>HTTP Connection Manager – Password with special characters (i.e. greater than \/ less than sign) cause issue in WSS Method (it needs encoding)<\/li>\n
  • NEW: <\/span>JSON Generator, XML Generator, Export Tasks – Add additional date formats in date format selection<\/li>\n
  • NEW: <\/span>JSON Source – Provide a way to supply different HTTP METHOD (verb) for Changing Pagination method (2nd page has different verb) – ConstantContact API usecase<\/li>\n
  • NEW: <\/span>PostgreSql Destination – Add Support for Array Type (i.e. text[ ], integer[ ] ) <\/li>\n
  • NEW: <\/span>PostgreSql Source – Add Support for Array Type (i.e. text[ ], integer[ ] ) <\/li>\n
  • NEW: <\/span>Secure FTP Connection Manager – Add an option to avoid errors with older server – Data connection cannot be opened with this PROT setting (521)<\/li>\n
  • NEW: <\/span>Secure FTP Task – For Rename File Operation – add Support for {%name_before_dot%}, {%filenum%}, {%totalfiles%}, {%timestamp%} placeholders<\/li>\n<\/ul>\n

    Bug fixes<\/h3>\n
      \n
    • FIX: <\/span>API Connection Manager – OAuth Generate Token button remains disabled in some cases also not showing count down<\/li>\n
    • FIX: <\/span>API Connector Framework – Columns from Base Template not working<\/li>\n
    • FIX: <\/span>API Connector Framework – Hidden Parameters not passed correctly to OptionEndPoint<\/li>\n
    • FIX: <\/span>API Connector Framework – Table Level Parameters not used from ODBC<\/li>\n
    • FIX: <\/span>API Connector Framework – ValueTemplate doesnt work for Query, Body Parameters and also in Input\/Output Columns, Also DirectPlaceholder function invoked in wrong order when you use Parameters in ValueTemplate<\/li>\n
    • FIX: <\/span>MongoDB Source, Amazon DynamoDB Source, Azure Table Source – Empty Table cause hang at runtime (infinite loop)<\/li>\n
    • FIX: <\/span>XML Generator Transform – Date format option is not working<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      Introduction This release brings tons of new features and bug fixes. We have added new connectors for Youtube, Stripe, Zoom, Amazon Ads and ManageEngine. It fixes important issues with MongoDB Source, Amazon DynamoDB Source, Azure Table Source, XML Generator Transform. To see full release notes\u00a0click here New Features\/Improvements NEW: General – Add support for SQL […]<\/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":"\r\nSSIS PowerPack 5.0.0 released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS PowerPack 5.0.0 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-5-0-0-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 5.0.0 released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS PowerPack 5.0.0 released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2023-08-02T10:48:47+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2023-08-02T13:56:43+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=\"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-5-0-0-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/\",\"name\":\"SSIS PowerPack 5.0.0 released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2023-08-02T10:48:47+00:00\",\"dateModified\":\"2023-08-02T13:56:43+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\"},\"description\":\"SSIS PowerPack 5.0.0 released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-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-5-0-0-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS PowerPack 5.0.0 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 5.0.0 released | ZappySys Blog","description":"SSIS PowerPack 5.0.0 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-5-0-0-released\/","og_locale":"en_US","og_type":"article","og_title":"SSIS PowerPack 5.0.0 released | ZappySys Blog","og_description":"SSIS PowerPack 5.0.0 released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/","og_site_name":"ZappySys Blog","article_published_time":"2023-08-02T10:48:47+00:00","article_modified_time":"2023-08-02T13:56:43+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/","url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/","name":"SSIS PowerPack 5.0.0 released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2023-08-02T10:48:47+00:00","dateModified":"2023-08-02T13:56:43+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35"},"description":"SSIS PowerPack 5.0.0 released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-5-0-0-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-5-0-0-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS PowerPack 5.0.0 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\/10147"}],"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=10147"}],"version-history":[{"count":2,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10147\/revisions"}],"predecessor-version":[{"id":10158,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/10147\/revisions\/10158"}],"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=10147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=10147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=10147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}