{"id":933,"date":"2017-01-11T17:26:33","date_gmt":"2017-01-11T17:26:33","guid":{"rendered":"http:\/\/zappysys.com\/blog\/?p=933"},"modified":"2025-11-06T21:36:27","modified_gmt":"2025-11-06T21:36:27","slug":"ssis-zip-file-task-compress-files-and-password-protect","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/","title":{"rendered":"SSIS Zip File Task &#8211; Compress files and password protect"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p>In this blog post, we will see how to compress and encrypt files with a password (zip and AES). We will use <a target=\"_blank\" rel=\"noopener\">the SSIS Zip File Task,\u00a0<\/a>which comes with many advanced options, including an encryption feature for password-protected zip files.<\/p>\n<p>NOTE: The Password feature is only available for the Zip file format. If you choose the GZip (*.gz) format, then the encryption feature is not available.<\/p>\n<h2>Zip multiple files using the SSIS Compression task.<\/h2>\n<p><span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">The SSIS Zip File Task can either create a zip file for each source file in the list (e.g., *.txt) or create one zip file for all files from the source.<\/span><\/p>\n<p>Here is the screenshot of how to zip multiple files<\/p>\n<div id=\"attachment_11611\" style=\"width: 674px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11611\" class=\"size-full wp-image-11611\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png\" alt=\"\" width=\"664\" height=\"758\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png 664w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password-263x300.png 263w\" sizes=\"(max-width: 664px) 100vw, 664px\" \/><\/a><p id=\"caption-attachment-11611\" class=\"wp-caption-text\">How to Compress multiple files using SSIS Zip file Task (Encrypt using Password)<\/p><\/div>\n<h2>Password-protect Zip file (AES encryption &#8211; AES128, AES256)<\/h2>\n<p>To protect a zip file with a password, specify the Password on the security tab and select the Encryption Algorithm. See below screenshot<\/p>\n<div id=\"attachment_11612\" style=\"width: 648px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/Password-protect-Zip-file-using-SSIS-Encrypt-using-AES256-algorithm-Hide-file-names-from-compressed-archive.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-11612\" class=\"size-full wp-image-11612\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/Password-protect-Zip-file-using-SSIS-Encrypt-using-AES256-algorithm-Hide-file-names-from-compressed-archive.png\" alt=\"\" width=\"638\" height=\"595\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/Password-protect-Zip-file-using-SSIS-Encrypt-using-AES256-algorithm-Hide-file-names-from-compressed-archive.png 638w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/Password-protect-Zip-file-using-SSIS-Encrypt-using-AES256-algorithm-Hide-file-names-from-compressed-archive-300x280.png 300w\" sizes=\"(max-width: 638px) 100vw, 638px\" \/><\/a><p id=\"caption-attachment-11612\" class=\"wp-caption-text\">Password-protect a Zip file using SSIS (Encrypt using AES256 algorithm, Hide file names from compressed archive)<\/p><\/div>\n<h2>Unzip password password-protected file<\/h2>\n<p>To unzip a password-protected file, you can use the same settings on the Security Tab, except change your source, target, and action.<\/p>\n<h2>Hide file list from encrypted Zip file (Double Zip Technique)<\/h2>\n<p>When you password-protect a Zip file, one common issue you may face is that it will allow anyone to see file names inside the archive (i.e., Zip file). Even though the file&#8217;s content is encrypted, you may still want to hide files stored in your archive. If you need to hide file names from the archive, then use the technique below.\u00a0 Basically, you have to double-zip\/encrypt. See the above screenshot.<\/p>\n<h2>Conclusion<\/h2>\n<p>Zip\/Unzip is the most common need while exchanging data. Securing files can be even more critical.\u00a0<span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">If you are an SSIS developer, you can use the SSIS Zip File Task with ease.<\/span> The zip file task is part of the\u00a0<a href=\"\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">SSIS PowerPack<\/a>. Try for free and explore many features that can save your time and give you peace of mind.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In this blog post, we will see how to compress and encrypt files with a password (zip and AES). We will use the SSIS Zip File Task,\u00a0which comes with many advanced options, including an encryption feature for password-protected zip files. NOTE: The Password feature is only available for the Zip file format. If you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11611,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[163],"tags":[168,166,167,170,12,4,169,165,164],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS Zip File Task - Compress files and password protect | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"Learn how to compress and password protect multiple files using SSIS Zip file task. It supports zip\/unzip for password protected archives too (AES256).\" \/>\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-zip-file-task-compress-files-and-password-protect\/\" \/>\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 Zip File Task - Compress files and password protect | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"Learn how to compress and password protect multiple files using SSIS Zip file task. It supports zip\/unzip for password protected archives too (AES256).\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/\" \/>\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=\"2017-01-11T17:26:33+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-11-06T21:36:27+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"664\" \/>\r\n\t<meta property=\"og:image:height\" content=\"758\" \/>\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-zip-file-task-compress-files-and-password-protect\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/\",\"name\":\"SSIS Zip File Task - Compress files and password protect | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png\",\"datePublished\":\"2017-01-11T17:26:33+00:00\",\"dateModified\":\"2025-11-06T21:36:27+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"Learn how to compress and password protect multiple files using SSIS Zip file task. It supports zip\/unzip for password protected archives too (AES256).\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png\",\"width\":664,\"height\":758,\"caption\":\"How to Compress multiple files using SSIS Zip file Task (Encrypt using Password)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS Zip File Task &#8211; Compress files and password protect\"}]},{\"@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 Zip File Task - Compress files and password protect | ZappySys Blog","description":"Learn how to compress and password protect multiple files using SSIS Zip file task. It supports zip\/unzip for password protected archives too (AES256).","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-zip-file-task-compress-files-and-password-protect\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Zip File Task - Compress files and password protect | ZappySys Blog","og_description":"Learn how to compress and password protect multiple files using SSIS Zip file task. It supports zip\/unzip for password protected archives too (AES256).","og_url":"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2017-01-11T17:26:33+00:00","article_modified_time":"2025-11-06T21:36:27+00:00","og_image":[{"width":664,"height":758,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.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-zip-file-task-compress-files-and-password-protect\/","url":"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/","name":"SSIS Zip File Task - Compress files and password protect | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png","datePublished":"2017-01-11T17:26:33+00:00","dateModified":"2025-11-06T21:36:27+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"Learn how to compress and password protect multiple files using SSIS Zip file task. It supports zip\/unzip for password protected archives too (AES256).","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2017\/01\/How-to-Compress-multiple-files-using-SSIS-Zip-file-Task-Encrypt-using-Password.png","width":664,"height":758,"caption":"How to Compress multiple files using SSIS Zip file Task (Encrypt using Password)"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-zip-file-task-compress-files-and-password-protect\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS Zip File Task &#8211; Compress files and password protect"}]},{"@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\/933"}],"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=933"}],"version-history":[{"count":6,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/933\/revisions"}],"predecessor-version":[{"id":11613,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/933\/revisions\/11613"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/11611"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}