{"id":9291,"date":"2021-04-22T04:03:18","date_gmt":"2021-04-22T04:03:18","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=9291"},"modified":"2021-04-22T04:03:18","modified_gmt":"2021-04-22T04:03:18","slug":"ssis-powerpack-4-1-0-released","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/","title":{"rendered":"SSIS PowerPack 4.1.0 released"},"content":{"rendered":"<h3 class=\"versubtitle\">Introduction<\/h3>\n<p>We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for <a href=\"https:\/\/zappysys.com\/api\/integration-hub\">popular API services<\/a>. We also added many new features\u00a0 in various tasks \/ components along with bug fixes \/ performance improvement features.<\/p>\n<p>To see full release notes <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/release-notes.htm\" target=\"_blank\" rel=\"noopener\">click here<\/a><\/p>\n<h3 class=\"versubtitle\">New Features\/Improvements<\/h3>\n<ul>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Amazon Storage Connection Manager &#8211; Provide ForcePathStyle option to access any S3 Protocol Compatible Cloud Service (i.e. cloudian, mini.io, veritas, splunk, netapp, oraclecloud and many more)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connection Manager &#8211; Add Clear Cookies Option for OAuth<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector &#8211; Amazon MWS &#8211; Increase timeout to 2400 from 500 because some reports can take 30-40 mins to export &#8211; This will avoid status check timeout error for some reports<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector &#8211; JIRA &#8211; New connector to Read\/ Write Issues, Worklog, Users, Project, Comments and other objects stored in Atlassian JIRA (Cloud version)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector &#8211; OData &#8211; Renamed $filter and $format parameters<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector &#8211; Zendesk &#8211; Add new endpoint get_ticket_attachments, updated ticket endpoints to use static columns<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector &#8211; Zoho &#8211; Renamed If-Modified-Since Parameter<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector Framework &#8211; Add new parameter Type=RowInput to allow parameters to be mapped in $Row$ Value (If Its not mapped then use default value &#8211; only if non empty)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector Framework &#8211; Add support for Key property for Header Parameter Type<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Connector Framework &#8211; Auto arrange parameters in Grid based on &lt;Param&gt; element order<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Source, Destination &#8211; Add Support for DateParseHandling (Parse as DatetimeOffset or String)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Source, Destination &#8211; Add support for InputColumn Label (Name can be used to generate Document \/ Body but Label should be used to display in mapping screen)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Source, Destination &#8211; Add support for ValueTemplate for Input and Output Columns<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Source, Destination &#8211; Change default guess mode to 10x for Dynamic Metadata EndPoints<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Source, Destination &#8211; Create Connector File Wizard saves Enum values as integer in Connector file<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>API Source, Destination &#8211; New attribute DotAsPath for EndPoint to support for Nested Attributes using dot separator in input column name (This will eliminate LayoutMap need and allow to skip unmapped columns from generated Document too)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Azure Storage Connection &#8211; Add Support for Custom Web Proxy<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Excel Connection Manager &#8211; Add an option to create new file if missing on request<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Add 3 additional Metadata Scanning options &#8211; treat String as DT_STR (ascii), change length for all string columns to max (i.e. 4000 \/ 8000), treat all string columns as DT_TEXT \/ DT_NTEXT<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Add new placeholder function FUN_TIMESTAMP_MS_UNIX<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Add new placeholder function JSON_TO_TEXT (Example &lt;&lt;[&#8216;A&#8217;,&#8217;B&#8217;,&#8217;C&#8217;]|~|$.data[*]|~|\\n,FUN_JSON_TO_TEXT&gt;&gt; should return A\\n\\B\\nC)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Add new placeholder functions HASH_FILE_MD5, HASH_FILE_MD5_HEX, HASH_FILE_SHA256, HASH_FILE_SHA256_HEX<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>General &#8211; Update Online Help file with more detailed list of available placeholder functions<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Google Data Connection Manager &#8211; Add Clear Cookies Option for Generate Token<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>HTTP Connection Manager &#8211; Provide TokenFunction property for DynamicToken Authentication &#8211; This will help some unique scenarios to use function after token extracted e.g. &lt;&lt;[$userid$]:[$token$],FUN_BASE64ENC&gt;&gt; )<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON, XML Source, Parser Transform &#8211; Add options (EnableRawOutputModeSingleRow and RawOutputDataRowTemplate) to wrap response under special template (i.e. { data: [ ] } ) &#8211; Helps to filter root level using JSONPath (i.e. [?(@code==&#8217;1&#8242;)] )<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON, XML, CSV Source &#8211; Allow Placeholders for Advanced Pagination body text (i.e. FirstPageBodyPart, NextPageBodyPart)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON, XML, CSV Source &#8211; Give option to treat Path as multiple URLs \/ File Paths (separated by double colon or new line) &#8211; This allows UNION style feature to aggregate results from multiple URLs which has mostly similar structure<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>JSON, XML, CSV Source, REST API Task &#8211; Automatically handle Unauthorized error on 301 redirect error due to Authorization header removal<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>MongoDB Connection Manager &#8211; Redirect to article when user try to connect to MongoDB Atlas and didnt supply correct settings<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>PostgreSql Connection Manager &#8211; Add Support Windows Authentication \/ Active Directory (GSS\/SSPI)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>PostgreSql Connection Manager &#8211; Provide a way to authenticate using Custom Client Certificate (*.pfx file)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>PostgreSql, Amazon Redshift Connection Manager &#8211; Add TcpKeepAlive Option to allow Tcp connection open for long running query<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>REST API Task, JSON, XML, CSV Source, Web API Destination &#8211; Allow to set Expect header to blank value to disable 100-Continue negotiation (Some servers with load balancer cause issue unless this option is disabled)<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Upsert Destination Task &#8211; Provide an option (TempPostExecuteCommand) &#8211; Custom SQL to execute right before final merge &#8211; after staging table is loaded from source data<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>Web API Destination &#8211; Allow new performance option to disable Expect 100-Continue negotiation &#8211; This improves POST requests significantly (Upto 10x) in some cases<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>XML Source &#8211; Exclude Element Names option not working when Enable Performance Mode is checked &#8211; Because of this you may get OutOfMemoryException with Large XML when Multiple Array Nodes found under same parent node<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>XML Source &#8211; Show warning for very large files on filter selection<\/li>\n<li><span class=\"verAdded\">NEW:\u00a0<\/span>XML, CSV Source Parser Transform &#8211; Add an option to allow to search and replace source data using Regex (Useful for CSV to remove custom escape character \\&#8221; or remove invalid characters from XML using Regular expression)<\/li>\n<\/ul>\n<h3 class=\"versubtitle\">Bug fixes<\/h3>\n<ul>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Amazon Redshift Connection Manager &#8211; UI Labels are overlapping with controls<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Connection Manager &#8211; Package fails to deploy if you use Embedded Mode (use of ConfigText Property)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Connector Framework &#8211; MultiSelect Parameters not decoded correctly in somecases<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Destination &#8211; Parameter Value entered via grid is not passed downstream<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Destination &#8211; Select Operation doesnt work (Fails with validation error about empty endpoint)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Source, Destination &#8211; Slash (i.e. &#8220;\\&#8221; ) is not escaped when saving parameter value &#8211; This may cause error &#8211; Bad JSON escape sequence<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Source, Destination &#8211; Pagination Starts at 1 regardless value supplied in URL (i.e startAt=0 )<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>API Source, Destination &#8211; Raw column indicator is not working property for Input Columns<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Azure Storage Connection &#8211; Custom Endpoint not allowed for Queue<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Azure Storage Connection &#8211; User defined values for Timeout, MaxRetryOnError, RetryInterval, MaxParallelThreads Properties are not used correctly<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>CSV Source, Parser Transform &#8211; When first row is blank and next row has number it detects datatype as String rather than Number<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Export JSON, XML, CSV Task, Amazon Redshift Data Transfer Task &#8211; OLEDB Connection with timeout error (Bad Host) threw misleading error about COM (Not showing actual underlying error in execution log)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Export XML Task, XML Generator Transform &#8211; Using Upper Case namespace prefix throws error &#8211; An item with the same key has already been added<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>General &#8211; After selecting example you cannot do Undo (Ctrl + Z)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>HTTP Connection Manager &#8211; Proxy \/ Client Certificate doesnt work for Dynamic Token Authentication<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>JSON Parser, XML Parser, Regex Parser Task &#8211; Description from Grid is not saved<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>OAuth Connection Manager &#8211; AWS Signature v4 fails if you supply URL parameters without proper encoded values (i.e. ?start=20:00 Fails but ?start=20%3A00 works)<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>OAuth Connection Manager &#8211; Cookies not cleared even though you check Logout option<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>OAuth Connection Manager &#8211; Mailchimp Default App Requires Redirect URL entered as https:\/\/zappysys.com\/oauth2 &#8211; Otherwise you will get error &#8211; The remote server returned an error (400) bad request<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>OAuth Connection Manager &#8211; Test connection button click shows misleading message [Test Connection Successful] in many cases when settings are not correct<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>OAuth Connection Manager &#8211; Token Extract fails using 3-legged authentication in Microsoft Edge Browser<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>Salesforce Destination &#8211; If set EnableBulkAPiMode=True and BulkApiVersion=2, Operation=Upsert &#8211; it may throw runtime error (Input string was not in a correct format) when you send NULL decimal, datetime, integer and Output is attached<\/li>\n<li><span class=\"verFixed\">FIX:\u00a0<\/span>XML Source, XML Parser Transform &#8211; Include Parent for Missing Child Option is not working when there is no child row in entire document for all parent rows<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction We are excited to release tons of new features and fixes in this version. It includes many enhancements around API Connector Framework to support new connectors for popular API services. We also added many new features\u00a0 in various tasks \/ components along with bug fixes \/ performance improvement features. To see full release notes [&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 4.1.0 released | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"SSIS PowerPack 4.1.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-4-1-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 4.1.0 released | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"SSIS PowerPack 4.1.0 released - ZappySys Blog\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-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=\"2021-04-22T04:03:18+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=\"7 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-4-1-0-released\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/\",\"name\":\"SSIS PowerPack 4.1.0 released | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png\",\"datePublished\":\"2021-04-22T04:03:18+00:00\",\"dateModified\":\"2021-04-22T04:03:18+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"SSIS PowerPack 4.1.0 released - ZappySys Blog\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-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-4-1-0-released\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS PowerPack 4.1.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\/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 4.1.0 released | ZappySys Blog","description":"SSIS PowerPack 4.1.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-4-1-0-released\/","og_locale":"en_US","og_type":"article","og_title":"SSIS PowerPack 4.1.0 released | ZappySys Blog","og_description":"SSIS PowerPack 4.1.0 released - ZappySys Blog","og_url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2021-04-22T04:03:18+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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/","url":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/","name":"SSIS PowerPack 4.1.0 released | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2015\/08\/zappysys-symbol-mid.png","datePublished":"2021-04-22T04:03:18+00:00","dateModified":"2021-04-22T04:03:18+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"SSIS PowerPack 4.1.0 released - ZappySys Blog","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-0-released\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-powerpack-4-1-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-4-1-0-released\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS PowerPack 4.1.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\/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\/9291"}],"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=9291"}],"version-history":[{"count":2,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9291\/revisions"}],"predecessor-version":[{"id":9392,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/9291\/revisions\/9392"}],"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=9291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=9291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=9291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}