{"id":6672,"date":"2019-03-30T09:48:44","date_gmt":"2019-03-30T09:48:44","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=6672"},"modified":"2019-12-28T06:58:52","modified_gmt":"2019-12-28T06:58:52","slug":"ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/","title":{"rendered":"SSIS Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders)"},"content":{"rendered":"<h2><span id=\"Introduction_8211_Using_SSIS_SFTP_task_FTP_SFTP_FTPS\">Introduction<\/span><\/h2>\n<p><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-6532 size-thumbnail\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo-150x150.png\" alt=\"Azure BLOB Storage\" width=\"150\" height=\"150\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo-150x150.png 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png 225w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a>In this article, we will show\u00a0<strong>SSIS Azure Blob Storage task examples<\/strong>. Uploading files using Azure Blob Storage Task or downloading files are common requirements in SSIS. In order to work with Azure Blob Storage, Microsoft SSIS includes the Azure Blob Storage Task that allows to upload files to Azure Blob Storage, download files, creating local and remote directories an more. In this article, we will show how to use the\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-azure-blob-storage-task\/\" target=\"_blank\" rel=\"noopener\">SSIS Azure Blob Storage task<\/a>\u00a0included in ZappySys\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\">SSIS PowerPack<\/a>.<\/p>\n<p>Azure Blob Storage Task can be used to perform various operations with Azure Storage objects (blobs and containers) (e.g. Download, Upload, Copy, Move, Rename, Delete, etc). You can also get single property of any Azure blob or get a list of blobs as ADO.net Table and which can be easily looped through using ForEachLoop Task. Most of the operations in this task support recursive search using wild card pattern (e.g. Myfile*.txt).<\/p>\n<h2><span id=\"Prerequisite\"><span id=\"Requirements\">Prerequisite<br \/>\n<\/span><\/span><\/h2>\n<ol>\n<li>First, you will need to have SSIS installed<\/li>\n<li>Secondly, make sure to have SSDT<\/li>\n<li>Download and install\u00a0<a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkId=717179&amp;clcid=0x4009\" target=\"_blank\" rel=\"noopener\">Microsoft Azure Storage Emulator<\/a><\/li>\n<li>Download and install\u00a0<a href=\"https:\/\/azure.microsoft.com\/en-us\/features\/storage-explorer\/\" target=\"_blank\" rel=\"noopener\">Microsoft Azure Storage Explorer<\/a><\/li>\n<li>Finally, do not forget to install\u00a0ZappySys\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">SSIS PowerPack<\/a><\/li>\n<\/ol>\n<p><strong>NOTE:<\/strong>\u00a0If you want to use Live account (Azure Blob Storage) then you can skip Step #3<\/p>\n<h2><span id=\"What_is_Azure_Blob_Storage\">What is Azure Blob Storage<\/span><\/h2>\n<p>Azure Blob storage is Microsoft\u2019s object storage solution for the cloud. you can store large amounts of unstructured data, such as text or binary data. Blob storage discloses three resources:<\/p>\n<ul>\n<li>Storage account (You can access data objects in Azure Storage through a storage account.<br \/>\nFor more information,\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/common\/storage-create-storage-account\" target=\"_blank\" rel=\"noopener\">click here<\/a>.)<\/li>\n<li>the containers in the account(constructs a set of blobs, it is similar to a folder in a file system.<br \/>\nAll blobs lie within a container,\u00a0<strong>Note:<\/strong>\u00a0Container name must be lowercase)<\/li>\n<li>the blobs in a container. (Azure Storage offers three types of blobs: block blobs, append blobs, and\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/storage\/blobs\/storage-blob-pageblob-overview\" target=\"_blank\" rel=\"noopener\">page blobs<\/a>)<br \/>\nSee the below-attached diagram. It shows the relationship between these resources.<br \/>\n<a href=\"https:\/\/i2.wp.com\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/blob1.png?ssl=1\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-3569 alignleft\" src=\"https:\/\/i2.wp.com\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/blob1.png?resize=258%2C131&amp;ssl=1\" alt=\"\" width=\"258\" height=\"131\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/blob1.png 329w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/blob1-300x152.png 300w\" sizes=\"(max-width: 258px) 100vw, 258px\" \/><\/a>\u00a0 \u00a0 \u00a0You can also use Azure Storage Explorer on your Local machine. Azure Storage Explorer is a standalone app that enables you to easily work with Azure Storage data on Windows, macOS, and Linux. You can use Blob storage to expose data publicly to the world or to store application data privately.\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/vs-azure-tools-storage-manage-with-storage-explorer#connect-to-a-storage-account-or-service\" target=\"_blank\" rel=\"noopener\">Connect to an Azure storage account or service<\/a><\/li>\n<\/ul>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<h2>Getting Started<\/h2>\n<p>In order to start, we will show several examples. ZappySys includes an <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-azure-blob-storage-task\/\" target=\"_blank\" rel=\"noopener\">SSIS Azure Blob Storage Task<\/a> that will allow you to access\u00a0files \/ folders from Azure Blob to the Local machine, Upload files(s) to Azure Blob Storage. It will also support Delete, Rename, List, Get Property, Copy, Move, Create, Set Permission \u2026 and many more operations. Here we are showing you is, How to upload, download, move and delete files \/ folders from Azure Blob Storage.<\/p>\n<p>You can connect to your Azure Storage Account by entering your storage account credentials. Here I am showing an example of the use of local Azure Storage Emulator.<\/p>\n<h2>Setup Azure Storage client tools<\/h2>\n<ol>\n<li>Once you have <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkId=717179&amp;clcid=0x4009\" target=\"_blank\" rel=\"noopener\">downloaded and installed storage emulator<\/a> You can launch Microsoft Azure Storage Emulator from its Physical location or from the desktop or start menu shortcut.\n<div id=\"attachment_3631\" style=\"width: 869px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3631\" class=\"wp-image-3631 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location.png\" alt=\"Microsoft Azure Storage Emulator Physical Location\" width=\"859\" height=\"94\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location.png 859w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location-300x33.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-location-768x84.png 768w\" sizes=\"(max-width: 859px) 100vw, 859px\" \/><\/a><p id=\"caption-attachment-3631\" class=\"wp-caption-text\">Microsoft Azure Storage Emulator Physical Location<\/p><\/div><\/li>\n<li>If You can see the below-attached Command Prompt screen after Emulator started. Then you can proceed to start Microsoft Azure Storage Explorer as the Azure Storage Emulator is started successfully.\n<div id=\"attachment_3633\" style=\"width: 710px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-screen-after-started.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3633\" class=\"wp-image-3633 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-emulator-screen-after-started-e1552723801433.png\" alt=\"Command Prompt Screen after Microsoft Azure Storage Emulator Started\" width=\"700\" height=\"237\" \/><\/a><p id=\"caption-attachment-3633\" class=\"wp-caption-text\">Command Prompt Screen after Microsoft Azure Storage Emulator Started<\/p><\/div><\/li>\n<li>Now, You have to <a href=\"https:\/\/azure.microsoft.com\/en-us\/features\/storage-explorer\/\" target=\"_blank\" rel=\"noopener\">download and install Microsoft Azure Storage Explorer<\/a> and then You can launch Microsoft Azure Storage Explorer from its Physical location or from the desktop or start menu shortcut.\n<div id=\"attachment_3635\" style=\"width: 837px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3635\" class=\"wp-image-3635 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location.png\" alt=\"Microsoft Azure Storage Explorer Physical Location\" width=\"827\" height=\"97\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location.png 827w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location-300x35.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-location-768x90.png 768w\" sizes=\"(max-width: 827px) 100vw, 827px\" \/><\/a><p id=\"caption-attachment-3635\" class=\"wp-caption-text\">Microsoft Azure Storage Explorer Physical Location<\/p><\/div><\/li>\n<\/ol>\n<h2>Create an Azure\u00a0Blob Storage Container<\/h2>\n<p>For Creating a Blob Container, First of all, you need to go to Microsoft Storage Explorer Window. Then you can go through like this way (Storage Accounts &#8211;&gt; (Development) &#8211;&gt; Blob Containers).<\/p>\n<div id=\"attachment_3637\" style=\"width: 556px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-blob-container.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3637\" class=\"wp-image-3637 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-blob-container-e1552723740747.png\" alt=\"Microsoft Azure Storage Explorer: Create Blob Container\" width=\"546\" height=\"584\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-blob-container-e1552723740747.png 546w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-blob-container-e1552723740747-280x300.png 280w\" sizes=\"(max-width: 546px) 100vw, 546px\" \/><\/a><p id=\"caption-attachment-3637\" class=\"wp-caption-text\">Microsoft Azure Storage Explorer: Create a Blob Container<\/p><\/div>\n<p>you can also create a Virtual Directory under it. A Virtual Directory does not actually exist in Azure until you paste, drag or upload blobs into it.<\/p>\n<div id=\"attachment_3638\" style=\"width: 730px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-new-virtual-directory-under-blob-container.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3638\" class=\"wp-image-3638 size-large\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-new-virtual-directory-under-blob-container-1024x749.png\" alt=\"Creating the new Virtual Directory under Blob Container\" width=\"720\" height=\"527\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-new-virtual-directory-under-blob-container-1024x749.png 1024w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-new-virtual-directory-under-blob-container-300x220.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-new-virtual-directory-under-blob-container-768x562.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/microsoft-azure-storage-explorer-create-new-virtual-directory-under-blob-container.png 1163w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/a><p id=\"caption-attachment-3638\" class=\"wp-caption-text\">Creating the new Virtual Directory under Blob Container<\/p><\/div>\n<h2>SSIS Azure Blob Storage Task Examples<\/h2>\n<p>Let\u00b4s start with an example. In this SSIS Azure Blob Storage Task File task example, we will upload, download, move and delete files \/ folders from Azure Blob Storage.<\/p>\n<ol>\n<li style=\"list-style-type: none\">\n<ol>\n<li>First\u00a0of All, Drag and Drop Azure Blob Storage Task from SSIS Toolbox and double click it to edit\n<div id=\"attachment_3639\" style=\"width: 613px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/zs-azure-blob-storage-task.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3639\" class=\"wp-image-3639 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/zs-azure-blob-storage-task.png\" alt=\"Drag and Drop Azure Blob Storage Task\" width=\"603\" height=\"271\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/zs-azure-blob-storage-task.png 603w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/04\/zs-azure-blob-storage-task-300x135.png 300w\" sizes=\"(max-width: 603px) 100vw, 603px\" \/><\/a><p id=\"caption-attachment-3639\" class=\"wp-caption-text\">Drag and Drop Azure Blob Storage Task<\/p><\/div><\/li>\n<li>The following options are available in Azure Blob Storage Task:\n<div id=\"attachment_6677\" style=\"width: 680px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-azure-storage-task-options.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6677\" class=\"wp-image-6677 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-azure-storage-task-options.png\" alt=\"Option to upload, download files in SSIS\" width=\"670\" height=\"616\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-azure-storage-task-options.png 670w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-azure-storage-task-options-300x276.png 300w\" sizes=\"(max-width: 670px) 100vw, 670px\" \/><\/a><p id=\"caption-attachment-6677\" class=\"wp-caption-text\">Options to upload, download files in SSIS<\/p><\/div><\/li>\n<li>You can also overwrite files and folder, skip all, overwrite if source is older, overwrite if the file size is different, rename files and more:\n<div id=\"attachment_6678\" style=\"width: 692px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/overwrite-action-ssis-za-am-task.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6678\" class=\"wp-image-6678 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/overwrite-action-ssis-za-am-task.png\" alt=\"Overwrite files in SSIS\" width=\"682\" height=\"492\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/overwrite-action-ssis-za-am-task.png 682w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/overwrite-action-ssis-za-am-task-300x216.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/a><p id=\"caption-attachment-6678\" class=\"wp-caption-text\">Overwrite files in SSIS<\/p><\/div><\/li>\n<li>Let&#8217;s select the <strong>Download Azure file(s) to local directory<\/strong>. Now select\/add The Source path, Check Recursive Scan to get all the sub files and sub folders and it&#8217;s files and add Target Path, This option will download files. In Path AccessMode we can use Direct to write the path directly or to use an SSIS variable.\n<div id=\"attachment_6735\" style=\"width: 595px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-download-files.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6735\" class=\"wp-image-6735 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-download-files.png\" alt=\"ssis-az-blob-aws-s3-download-files\" width=\"585\" height=\"522\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-download-files.png 585w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-download-files-300x268.png 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><p id=\"caption-attachment-6735\" class=\"wp-caption-text\">SSIS Azure Blob Storage Task \u2013 Download files from Azure Blob Storage<\/p><\/div><\/li>\n<li>That&#8217;s it now execute the package and it will download all the files and sub folders from the Azure Blob Storage Task to Local File Machine.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ol>\n<li>Now Let&#8217;s configure the task to upload the local directory files and folder to Azure Blob Storage like below and execute the package. And also in this example i created the variable and stored target folder path in it and used that variable Target Path Variable.\n<div id=\"attachment_6759\" style=\"width: 595px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-upload-files.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6759\" class=\"wp-image-6759 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-upload-files.png\" alt=\"SSIS Azure Blob Storage Task \u2013 Upload files from Azure Blob Storage\" width=\"585\" height=\"523\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-upload-files.png 585w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-upload-files-300x268.png 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><p id=\"caption-attachment-6759\" class=\"wp-caption-text\">SSIS Azure Blob Storage Task \u2013 Upload files from Azure Blob Storage<\/p><\/div><\/li>\n<li>Let&#8217;s configure the task to delete Azure Blob Storage files like below and execute the package.\n<div id=\"attachment_6743\" style=\"width: 591px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-delete-files.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6743\" class=\"wp-image-6743 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-delete-files.png\" alt=\"SSIS Azure Blob Storage Task \u2013 Delete files from Azure Blob Storage\" width=\"581\" height=\"523\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-delete-files.png 581w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-delete-files-300x270.png 300w\" sizes=\"(max-width: 581px) 100vw, 581px\" \/><\/a><p id=\"caption-attachment-6743\" class=\"wp-caption-text\">SSIS Azure Blob Storage Task \u2013 Delete files from Azure Blob Storage<\/p><\/div><\/li>\n<li>Let&#8217;s configure the task to move Azure Blob Storage files to another directory like below and execute the package.\n<div id=\"attachment_6746\" style=\"width: 566px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-move-files.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6746\" class=\"wp-image-6746 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-move-files.png\" alt=\"SSIS Azure Blob Storage Task \u2013 Move files from Azure Blob Storage\" width=\"556\" height=\"476\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-move-files.png 556w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-move-files-300x257.png 300w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/a><p id=\"caption-attachment-6746\" class=\"wp-caption-text\">SSIS Azure Blob Storage Task \u2013 Move files from Azure Blob Storage<\/p><\/div><\/li>\n<li>That&#8217;s it like upper examples you can configure Azure Blob Storage Task to use it&#8217;s other options also.<\/li>\n<li>Let&#8217;s see other SSIS Azure Blob Storage Task examples in below sections<\/li>\n<\/ol>\n<h2>Working with advanced filters<\/h2>\n<p>In order to understand filters, we will create an example for you. This time we will create SSIS Azure Blob Storage task example to show how to exclude some files from the downloading process.<\/p>\n<ol>\n<li>In addition, it is also possible to add advanced filters to the SSIS Azure Blob Storage task to exclude or include files and folders. The following example shows how to use the Advanced filters. In the <strong>Azure Blob Storage\u00a0Task,\u00a0<\/strong>go to the Advanced Filter page and in Exclude RegX we will write \\.exe$ to exclude the file with exe extension to be downloaded. You can use RegX (regular expressions) in the advanced filter:\n<div id=\"attachment_6693\" style=\"width: 691px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-advanced-filters.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6693\" class=\"wp-image-6693 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-advanced-filters.png\" alt=\"Advanced filters\" width=\"681\" height=\"487\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-advanced-filters.png 681w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-advanced-filters-300x215.png 300w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/a><p id=\"caption-attachment-6693\" class=\"wp-caption-text\">Advanced filters<\/p><\/div><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h2>Working with wildcards in\u00a0SSIS Azure Blob Storage task (Multiple files only)<\/h2>\n<p>In order to understand wildcards, the new example will show how to work with Wildcards will help you to work with multiple files or folder with common characteristics.<\/p>\n<ol>\n<li>The following example shows how to copy all the files will all the extensions in the source folder. We use the *.*, which means that any file name with any extension will be downloaded:\n<div id=\"attachment_6695\" style=\"width: 690px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-wildcards.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6695\" class=\"wp-image-6695 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-wildcards.png\" alt=\"Working with Wildcards\" width=\"680\" height=\"487\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-wildcards.png 680w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-wildcards-300x215.png 300w\" sizes=\"(max-width: 680px) 100vw, 680px\" \/><\/a><p id=\"caption-attachment-6695\" class=\"wp-caption-text\">Working with Wildcards<\/p><\/div><\/li>\n<li>If we want to download all the files with extension txt, use the following Path:\n<pre class=\"lang:amigados highlight:0 decode:true\">\/source\/*.txt;<\/pre>\n<\/li>\n<li>Another example would be to download all the files with the following names: file1.txt, file2.txt and file3.txt.\u00a0 We could use the following Path:\n<pre class=\"lang:default highlight:0 decode:true\">\/source\/file?.txt<\/pre>\n<\/li>\n<\/ol>\n<h2><\/h2>\n<h2><strong>Working with SSIS expressions and variables in Azure Blob Storage Task<\/strong><\/h2>\n<p>In order to understand expressions, the following example will show how to work with SSIS expressions combined with variables in the SSIS Azure Blob Storage task. In this example we will delete files in Azure Blob Storage using variables and expressions.<\/p>\n<div class=\"messageTextWrapper\">\n<p class=\"urlPreviewText\">ZappySys Providers simple and powerful Placeholders. You can still use SSIS expression language. Placeholders allow direct Variable Use easy to see compared to hidden SSIS Expression (C# style). Placeholders have simple embedding use of variables.<\/p>\n<\/div>\n<ol>\n<li>\u00a0First, we will first create a variable in SSIS. In this example the file name is <strong>MyFile<\/strong> and the Value<strong> file1<\/strong>.\n<div id=\"attachment_2994\" style=\"width: 782px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-2994\" class=\"size-full wp-image-2994\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable.png\" alt=\"Create a SSIS variable\" width=\"772\" height=\"205\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable.png 772w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable-300x80.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis.sftp-variable-768x204.png 768w\" sizes=\"(max-width: 772px) 100vw, 772px\" \/><\/a><p id=\"caption-attachment-2994\" class=\"wp-caption-text\">Create an SSIS variable<\/p><\/div><\/li>\n<li>As a second step, we will write in path the value<strong>\u00a0\\destination\\{{User.MyFile}}.txt.\u00a0<\/strong>This will concatenate the folder destination with the variable MyFile. The task will delete the file1.txt from the Azure Blob Storage folder.\n<div id=\"attachment_6699\" style=\"width: 687px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-variable-in-path.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6699\" class=\"wp-image-6699 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-variable-in-path.png\" alt=\"Using SSIS expressions\" width=\"677\" height=\"487\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-variable-in-path.png 677w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-working-with-variable-in-path-300x216.png 300w\" sizes=\"(max-width: 677px) 100vw, 677px\" \/><\/a><p id=\"caption-attachment-6699\" class=\"wp-caption-text\">Using SSIS expressions<\/p><\/div><\/li>\n<li>The next example will show how to create a Azure Blob Storage file using expressions and variables in SSIS:\n<div id=\"attachment_6700\" style=\"width: 689px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-aws-task-create-file.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6700\" class=\"wp-image-6700 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-aws-task-create-file.png\" alt=\"Create file\" width=\"679\" height=\"481\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-aws-task-create-file.png 679w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-aws-task-create-file-300x213.png 300w\" sizes=\"(max-width: 679px) 100vw, 679px\" \/><\/a><p id=\"caption-attachment-6700\" class=\"wp-caption-text\">Create file<\/p><\/div><\/li>\n<li>Content to write is the content of the file. In\u00a0<strong>Target,\u00a0<\/strong>go to path and write the following: For more information on placeholders <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/ssis-format-specifiers.htm#A1\" target=\"_blank\" rel=\"noopener\">check this post<\/a>\u00a0and also check <a href=\"https:\/\/zappysys.zendesk.com\/hc\/en-us\/articles\/115004918633-How-to-format-Path-URL-using-date-time-format\" target=\"_blank\" rel=\"noopener\">this post<\/a>.\n<pre class=\"lang:amigados highlight:0 decode:true\">\/destination\/{{User::FileName,MM-dd-yyyy}}<\/pre>\n<\/li>\n<li>We are using a variable in SSIS named FileName of type DateTime. We are concatenating the Azure Blob Storage folder destination with the variable. As you can see, the expressions with ZappySys are very simple.<\/li>\n<\/ol>\n<h2>Example to verify if file exists in SSIS Azure Blob Storage task<\/h2>\n<p>Finally, we will verify if a file in Azure Blob Storage exists or not using the SSIS Azure Blob Storage task.<\/p>\n<ol>\n<li>In order to start, we will use the SSIS variables, create a variable of Boolean type named FileExists. In\u00a0<strong>Storage Action,\u00a0<\/strong>select\u00a0<strong>Get Azure file exist status.\u00a0<\/strong>In path, select the path of the file to verify if it exists or not.\n<div id=\"attachment_6749\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-file-exist.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6749\" class=\"wp-image-6749 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-file-exist.png\" alt=\"SSIS Azure Blob Storage Task \u2013 Check File Exist in Azure Blob Storage\" width=\"583\" height=\"523\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-file-exist.png 583w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-blob-aws-s3-file-exist-300x269.png 300w\" sizes=\"(max-width: 583px) 100vw, 583px\" \/><\/a><p id=\"caption-attachment-6749\" class=\"wp-caption-text\">SSIS Azure Blob Storage Task \u2013 Check File Exist in Azure Blob Storage<\/p><\/div><\/li>\n<li>Secondly, we will use the\u00a0<strong>ZS Logging Task\u00a0<\/strong>to check the value of the variable File Exists. This task will show the value of the variable in the log. Drag and drop the task and join it with the ZS Azure Blob Storage Task:\n<div id=\"attachment_6702\" style=\"width: 279px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-to-log-task.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6702\" class=\"wp-image-6702 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-az-to-log-task.png\" alt=\"The SSIS Log task\" width=\"269\" height=\"260\" \/><\/a><p id=\"caption-attachment-6702\" class=\"wp-caption-text\">The SSIS Log task<\/p><\/div><\/li>\n<li>In order to get the value, we will insert it in the Logging Task. To do that, insert the Variable and select the FileExists variable:\n<div id=\"attachment_3005\" style=\"width: 634px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftp-verify-folder-exists.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3005\" class=\"size-full wp-image-3005\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftp-verify-folder-exists.png\" alt=\"Configuring variable\" width=\"624\" height=\"501\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftp-verify-folder-exists.png 624w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/ssis-ftp-verify-folder-exists-300x241.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><p id=\"caption-attachment-3005\" class=\"wp-caption-text\">Add the variable in the task logging<\/p><\/div><\/li>\n<li>Finally, run the package and verify the Output (you can use View and Output to see the output) and check the value of the Logging Task. If the file exists, the value will be true. If it does not exist, the value will be false.\n<div id=\"attachment_3004\" style=\"width: 1036px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-3004\" class=\"size-full wp-image-3004\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables.png\" alt=\"Verify the value of the variable in the SSIS output\" width=\"1026\" height=\"234\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables.png 1026w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables-300x68.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables-768x175.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2018\/03\/SFTP-read-variables-1024x234.png 1024w\" sizes=\"(max-width: 1026px) 100vw, 1026px\" \/><\/a><p id=\"caption-attachment-3004\" class=\"wp-caption-text\">Verify the variable in Output<\/p><\/div><\/li>\n<\/ol>\n<h2>How to loop through Azure Blob Storage files in SSIS<\/h2>\n<p>You can also loop through files to perform custom action file by by. Azure Blob Storage Task support Action to <strong>get File List as ADO.net Recordset<\/strong><\/p>\n<p>To get File list from Azure Blob Storage Server perform the following steps.<\/p>\n<ol>\n<li>From Storage Action select <strong><strong>Get Azure files as ADO.net DataTable<br \/>\n<\/strong><\/strong><\/p>\n<div id=\"attachment_6703\" style=\"width: 615px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-get-files-as-ado.net-datatable.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6703\" class=\"wp-image-6703 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-get-files-as-ado.net-datatable.png\" alt=\"Get files as ADO.net DataTable\" width=\"605\" height=\"295\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-get-files-as-ado.net-datatable.png 605w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/ssis-get-files-as-ado.net-datatable-300x146.png 300w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><p id=\"caption-attachment-6703\" class=\"wp-caption-text\">Get files as ADO.net DataTable<\/p><\/div>\n<p>&nbsp;<\/li>\n<li>Create new Azure Blob Storage Connection by clicking New next to connection dropdown.<\/li>\n<li>Select Source Path (e.g\u00a0 <strong>\\myroot\\folder\\*.txt\u00a0<\/strong> )<\/li>\n<li>Select or create new SSIS Variable (e.g. <strong>varFiles<\/strong> ) which will hold file list result (Must be Object datatype variable).<\/li>\n<li>Click OK to close.<\/li>\n<li>Create 3 more SSIS variables to hold File Path (String), Name (String) and Size (Int32). We will use in the next step.<\/li>\n<li>Now drag SSIS ForEach Loop Container Task from SSIS Toolbox<\/li>\n<li>Edit Loop Task and Select <strong>Foreach ADO Enumerator<\/strong> from the Enumerator dropdown<\/li>\n<li>Select variable (e.g.\u00a0<strong><strong>varFiles)<br \/>\n<\/strong><\/strong><\/p>\n<div id=\"attachment_346\" style=\"width: 635px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-346\" class=\"wp-image-346 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset.png\" alt=\"Loop through files in SSIS using ForEach Loop Task (use ADO.net Recordset variable)\" width=\"625\" height=\"563\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset.png 625w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-300x270.png 300w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/a><p id=\"caption-attachment-346\" class=\"wp-caption-text\">Loop through files in SSIS using ForEach Loop Task (use ADO.net Recordset variable)<\/p><\/div><\/li>\n<li>Click on Variable Mappings Tab and configure like below.\n<div id=\"attachment_345\" style=\"width: 582px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-variable-mapping.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-345\" class=\"size-full wp-image-345\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-variable-mapping.png\" alt=\"Variable Mappings for ForEach Loop Task - Loop through files in a folder using SSIS\" width=\"572\" height=\"272\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-variable-mapping.png 572w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2016\/02\/ssis-looping-through-files-ado-net-recordset-variable-mapping-300x143.png 300w\" sizes=\"(max-width: 572px) 100vw, 572px\" \/><\/a><p id=\"caption-attachment-345\" class=\"wp-caption-text\">Variable Mappings for ForEach Loop Task &#8211; Loop through files in a folder using SSIS<\/p><\/div><\/li>\n<li>Drag ZS Logging Task and place inside Loop and Display variables<\/li>\n<li>That&#8217;s it<\/li>\n<\/ol>\n<p>For more information to <a href=\"\/\/zappysys.com\/blog\/get-list-of-files-and-folders-in-ssis-for-looping\/\" target=\"_blank\" rel=\"noopener\">loop through files on local machine using SSIS check this article<\/a>.<\/p>\n<h2>Conclusion<\/h2>\n<p>To conclude, we can say that working with Azure Blob Storage is now very simple. In this article, we looked at SSIS Azure Blob Storage Task examples\u00a0on how to upload, download, delete files and folders. We used variables, wildcards and expressions. If you liked the tasks you can start using them by downloading SSIS PowerPack from our <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">web site here<\/a>. We saw different SSIS Azure Blob Storage Task examples to understand how to use the task in different scenarios.<\/p>\n<p>Thanks for your time.<\/p>\n<h2>References<\/h2>\n<ul>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">About SSIS PowerPack<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/integration-services\/expressions\/integration-services-ssis-expressions\" target=\"_blank\" rel=\"noopener\">Integration Services (SSIS) Expressions<\/a><\/li>\n<li>Help File :\u00a0<a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/index.htm#page=azure-cloud-storage-task.htm\" target=\"_blank\" rel=\"noopener\">Azure Storage Task<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In this article, we will show\u00a0SSIS Azure Blob Storage task examples. Uploading files using Azure Blob Storage Task or downloading files are common requirements in SSIS. In order to work with Azure Blob Storage, Microsoft SSIS includes the Azure Blob Storage Task that allows to upload files to Azure Blob Storage, download files, creating [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":6532,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[460,182],"tags":[183,479,12,478],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>SSIS Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders) | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"In this post we will see SSIS Azure Blob Storage Task examples to download, upload, move, copy, delete files\/folders to \/ from Local and remote directories.\" \/>\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-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/\" \/>\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 Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders) | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"In this post we will see SSIS Azure Blob Storage Task examples to download, upload, move, copy, delete files\/folders to \/ from Local and remote directories.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/\" \/>\r\n<meta property=\"og:site_name\" content=\"ZappySys Blog\" \/>\r\n<meta property=\"article:published_time\" content=\"2019-03-30T09:48:44+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2019-12-28T06:58:52+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"225\" \/>\r\n\t<meta property=\"og:image:height\" content=\"225\" \/>\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=\"11 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-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/\",\"url\":\"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/\",\"name\":\"SSIS Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders) | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png\",\"datePublished\":\"2019-03-30T09:48:44+00:00\",\"dateModified\":\"2019-12-28T06:58:52+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35\"},\"description\":\"In this post we will see SSIS Azure Blob Storage Task examples to download, upload, move, copy, delete files\/folders to \/ from Local and remote directories.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png\",\"width\":225,\"height\":225,\"caption\":\"Azure BLOB Storage\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SSIS Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders)\"}]},{\"@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 Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders) | ZappySys Blog","description":"In this post we will see SSIS Azure Blob Storage Task examples to download, upload, move, copy, delete files\/folders to \/ from Local and remote directories.","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-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/","og_locale":"en_US","og_type":"article","og_title":"SSIS Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders) | ZappySys Blog","og_description":"In this post we will see SSIS Azure Blob Storage Task examples to download, upload, move, copy, delete files\/folders to \/ from Local and remote directories.","og_url":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/","og_site_name":"ZappySys Blog","article_published_time":"2019-03-30T09:48:44+00:00","article_modified_time":"2019-12-28T06:58:52+00:00","og_image":[{"width":225,"height":225,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png","type":"image\/png"}],"author":"ZappySys","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ZappySys","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/","url":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/","name":"SSIS Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders) | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png","datePublished":"2019-03-30T09:48:44+00:00","dateModified":"2019-12-28T06:58:52+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/c9dc782c929d0027e2e87e3951ce9d35"},"description":"In this post we will see SSIS Azure Blob Storage Task examples to download, upload, move, copy, delete files\/folders to \/ from Local and remote directories.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/03\/AzureStorageLogo.png","width":225,"height":225,"caption":"Azure BLOB Storage"},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/ssis-azure-blob-storage-task-examples-download-upload-move-delete-files-folders\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SSIS Azure Blob Storage Task Examples (Download, Upload, Delete files \/ folders)"}]},{"@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\/6672"}],"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=6672"}],"version-history":[{"count":21,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6672\/revisions"}],"predecessor-version":[{"id":8640,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/6672\/revisions\/8640"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/6532"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=6672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=6672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=6672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}