{"id":7604,"date":"2019-08-06T12:47:38","date_gmt":"2019-08-06T12:47:38","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=7604"},"modified":"2019-10-01T11:37:27","modified_gmt":"2019-10-01T11:37:27","slug":"read-write-azure-queue-storage-data-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/read-write-azure-queue-storage-data-ssis\/","title":{"rendered":"How to Read\/Write Azure Queue Storage data in SSIS"},"content":{"rendered":"

Introduction<\/h2>\n

\"\"<\/a>In our previous blog, we saw you how to read\/write Azure Table Storage<\/a> data. Now in this blog, we will see\u00a0How to Read\/Write Azure Queue Storage data in SSIS.\u00a0To illustrate, we will use\u00a0ZappySys SSIS PowerPack<\/a>, which includes several tasks to import\/export data from multiples sources to multiple destinations like flat files, Azure, AWS, databases, Office files and more. They are\u00a0Coding free, drag and drop high-performance suite of\u00a0Custom SSIS Components<\/em>\u00a0and\u00a0SSIS Tasks.<\/em>\u00a0If you like perform other operations on Azure Blob Storage Files (e.g. Download, Upload, Create, Delete) then\u00a0check these articles<\/a>.<\/p>\n

In nutshell,\u00a0this post will focus on How to Read\/Write Azure Queue Storage data in SSIS using the following Source\/Destination.<\/p>\n

 <\/p>\n

Component Mentioned in this article<\/h2>\n
\n\n\n\n\n
\"\"<\/a><\/td>\nAzure Queue Storage Source<\/a><\/td>\n<\/tr>\n
\"\"<\/a><\/td>\nAzure Queue Storage Destination<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

Prerequisite<\/span><\/span><\/h2>\n
    \n
  1. First, you will need to have SSIS installed<\/li>\n
  2. Secondly, make sure to have SSDT<\/li>\n
  3. Download and install\u00a0Microsoft Azure Storage Emulator<\/a><\/li>\n
  4. Download and install\u00a0Microsoft Azure Storage Explorer<\/a><\/li>\n
  5. Finally, do not forget to install\u00a0ZappySys\u00a0SSIS PowerPack<\/a><\/li>\n<\/ol>\n

    NOTE:<\/strong>\u00a0If you want to use Live account (Azure Storage) then you can skip Step #3<\/p>\n

    What are Azure Queues?<\/h2>\n

    Azure Queue storage is a service for storing large numbers of messages. You access messages from anywhere in the world via authenticated calls using HTTP or HTTPS. A queue message can be up to 64 KB in size. A queue may contain millions of messages, up to the total capacity limit of a storage account.<\/p>\n

    Common uses<\/h3>\n
    \"Microsoft<\/a>

    Microsoft Azure Queue Concept<\/p><\/div>\n

    Common uses of Queue storage include:<\/p>\n