{"id":7799,"date":"2019-08-19T12:17:48","date_gmt":"2019-08-19T12:17:48","guid":{"rendered":"https:\/\/zappysys.com\/blog\/?p=7799"},"modified":"2020-02-05T15:42:23","modified_gmt":"2020-02-05T15:42:23","slug":"read-write-amazon-sqs-queue-data-ssis","status":"publish","type":"post","link":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/","title":{"rendered":"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS"},"content":{"rendered":"<h2>Introduction<\/h2>\n<p><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-thumbnail wp-image-7800 alignleft\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512-150x150.png\" alt=\"\" width=\"150\" height=\"150\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512-150x150.png 150w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512-300x300.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png 512w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/><\/a>ZappySys provides high-performance drag and drop connectors for Amazon AWS Integration. In this post, we will see How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS using ZS Amazon SQS components. ZappySys developed many AWS related components but in this article, we will look at 2 components for Amazon SQS Queue integration Scenarios (Read and Write). We will discuss how to use <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-sqs-source-connector\/\" target=\"_blank\" rel=\"noopener\">SSIS Amazon SQS Source<\/a> and <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-sqs-destination-connector\/\" target=\"_blank\" rel=\"noopener\">SSIS Amazon SQS Destination.<\/a> <i>Amazon SQS Source<\/i>\u00a0can be used to read messages from Amazon AWS SQS (Simple Queue Storage) and\u00a0<i>Amazon SQS Destination<\/i>\u00a0can be used to write\/delete data from Amazon SQS (Simple Queue Storage) using SSIS.<\/p>\n<p>&nbsp;<\/p>\n<h2>Prerequisite<\/h2>\n<p>Before we perform the steps listed in this article, you will need to make sure the following prerequisites are met:<\/p>\n<ul>\n<li>First, you will need to have SSIS installed.<\/li>\n<li>Secondly, make sure to have SSDT.<\/li>\n<li>Thirdly, you have obtained Amazon SQS Credentials.<\/li>\n<li>Finally, do not forget to install\u00a0<a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">ZappySys\u00a0SSIS PowerPack.<\/a><\/li>\n<\/ul>\n<h2>Component Mention in this article<\/h2>\n<div class=\"su-table su-table-alternate\">\n<table style=\"height: 44px;width: 307px\">\n<tbody>\n<tr style=\"height: 22px\">\n<td style=\"height: 22px;width: 1px\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-amazon-sqs-source.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3074\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-amazon-sqs-source.png\" alt=\"\" width=\"40\" height=\"40\" \/><\/a><\/td>\n<td style=\"height: 22px;width: 247px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-sqs-source-connector\/\" target=\"_blank\" rel=\"noopener\">Amazon SQS Source Connector<\/a><\/td>\n<\/tr>\n<tr style=\"height: 22px\">\n<td style=\"height: 22px;width: 1px\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3074\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination.png\" alt=\"\" width=\"40\" height=\"40\" \/><\/a><\/td>\n<td style=\"height: 22px;width: 247px\"><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-sqs-destination-connector\/\" target=\"_blank\" rel=\"noopener\">Amazon SQS Destination Connector<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2>What is Amazon SQS (Simple Queue Service)<\/h2>\n<p>Before we talk\u00a0<strong>How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS\u00a0<\/strong>lets talk What is Amazon SQS (Simple Queue Service) or sometimes referred to as AWS SQS.\u00a0Amazon SQS offers a secure, durable, and available hosted queue that lets you integrate and decouple distributed software systems and components. Amazon SQS offers common constructs such as\u00a0<a href=\"https:\/\/docs.aws.amazon.com\/AWSSimpleQueueService\/latest\/SQSDeveloperGuide\/sqs-dead-letter-queues.html\" target=\"_blank\" rel=\"noopener\">dead-letter queues<\/a>\u00a0and\u00a0<a href=\"https:\/\/docs.aws.amazon.com\/AWSSimpleQueueService\/latest\/SQSDeveloperGuide\/sqs-queue-tags.html\" target=\"_blank\" rel=\"noopener\">costs allocation tags<\/a>. It provides a generic web services API and it can be accessed by any programming language that the AWS SDK supports.<\/p>\n<p>SQS offers two types of message queues. Standard queues offer maximum throughput, best-effort ordering, and at-least-once delivery. SQS FIFO queues are designed to guarantee that messages are processed exactly once, in the exact order that they are sent.<\/p>\n<h2>Getting Started<\/h2>\n<p>In order to start, we will show several examples. ZappySys includes an Amazon SQS Source and Amazon SQS Destination, that will help you\u00a0How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS. You can connect to your Amazon SQS account by entering credentials.<\/p>\n<p><i>Amazon SQS Source<\/i>\u00a0can be used to read messages from Amazon AWS SQS (Simple Queue Storage) using SSIS. Read\u00a0Amazon SQS Messages (AWS SQS) in bulk.\u00a0<i>Amazon SQS Destination<\/i>\u00a0can be used to write\/delete data from Amazon SQS (Simple Queue Storage) using SSIS. Write messages to Amazon SQS (AWS SQS) in bulk. Support\u00a0for Visibility Timeout (Hide messages from others for certain time after you read), data preview and max rows, reading message attributes in separate output columns and\u00a0adjusting UTC DateTime in local time.<\/p>\n<h2>Write Data using Amazon SQS Destination in SSIS<\/h2>\n<h3>Overview<\/h3>\n<p>In this tutorial, you will learn how to write data in Amazon SQS Queue storage. You can use <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/dummydata-source.htm\" target=\"_blank\" rel=\"noopener\">ZS DummyData Source<\/a> for practice it or select suitable <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/index.htm#page=ssis-source-adapters.htm\" target=\"_blank\" rel=\"noopener\">ZS Source Adapters<\/a>. In this case its from ZS DummyData Source. So let&#8217;s start with an example, In this section, you will learn how to write messages into Amazon SQS Queue. For this example, we are assuming that you have already SQS Queue Created.<\/p>\n<h3>Create Amazon SQS Connection<\/h3>\n<ol>\n<li>Firstly, In order to connect to Amazon SQS from SSIS, you will need Access Key and Secret Key (Login to AWS portal and Create Access\/Secret Key with SQS service read access). If you are not sure about this ask your SysAdmin or responsible person to provide that to you. Your key will look something like this: <strong>(This is just an example key which may differ in your case).<br \/>\n<\/strong><\/p>\n<pre class=\"lang:default decode:true\">AccessKey: AKIAIOSFODNN7EXAMPLE\r\nSecretKey: wJalrXUtnFEMI\/K7MDENG\/bPxRfiCYEXAMPLEKEY<\/pre>\n<p><a href=\"http:\/\/docs.aws.amazon.com\/IAM\/latest\/UserGuide\/id_credentials_access-keys.html\" target=\"_blank\" rel=\"noopener\">Click here<\/a>\u00a0to read more about how to get your AccessKey and Secret Key.<\/li>\n<li>Secondly, Once you have Account Key (it&#8217;s like UserID) and Secret Key (its like password) you may proceed to create a new SSIS package. In BIDS\/SSDT create a new SSIS package.<\/li>\n<li>Right-click in Connection Manager Panel and Select [New Connection] menu item.\n<div style=\"width: 268px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-dynamodb-destination\/ssis-aws-dynamodb-pick-connection-type-click.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-dynamodb-destination\/ssis-aws-dynamodb-pick-connection-type-click.png\" alt=\"SSIS Create AWS Storage Connection\" width=\"258\" height=\"182\" \/><\/a><p class=\"wp-caption-text\">SSIS Create AWS Storage Connection<\/p><\/div><\/li>\n<li>Now Select ZS-AWS-STORAGE connection type.\n<div style=\"width: 424px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-dynamodb-destination\/ssis-aws-dynamodb-pick-connection-type.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-dynamodb-destination\/ssis-aws-dynamodb-pick-connection-type.png\" alt=\"Select ZS-AWS-STORAGE Connection\" width=\"414\" height=\"321\" \/><\/a><p class=\"wp-caption-text\">Select ZS-AWS-STORAGE Connection<\/p><\/div><\/li>\n<li>Let&#8217;s configure the Amazon SQS connection. Set Storage Service to SQS and Credential Type to Key-based access control. In the General tab enter your Amazon SQS Credentials and Set Default region as per you have.\n<div style=\"width: 603px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-amazon-sqs-source-create-new-connection.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-amazon-sqs-source-create-new-connection.png\" alt=\"SSIS AWS Storage Connection - Configure\" width=\"593\" height=\"667\" \/><\/a><p class=\"wp-caption-text\">SSIS AWS Storage Connection &#8211; Configure<\/p><\/div><\/li>\n<li>In the last, click on Test Connection and OK button to Save connection configure setting UI.<\/li>\n<\/ol>\n<h3>Write Data into Amazon SQS<\/h3>\n<ol>\n<li>Once you have created the Amazon SQS Connection successfully, let&#8217;s drag and Drop Data Flow Task from SSIS Toolbox on the control flow designer surface.\n<div id=\"attachment_7934\" style=\"width: 470px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7934\" class=\"wp-image-7934 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png\" alt=\"Drag and Drop SSIS Data Flow Task from SSIS Toolbox\" width=\"460\" height=\"155\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task.png 460w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/09\/ssis-drag-drop-data-flow-task-300x101.png 300w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/a><p id=\"caption-attachment-7934\" class=\"wp-caption-text\">Drag and Drop SSIS Data Flow Task from SSIS Toolbox<\/p><\/div><\/li>\n<li>Double click on the Data Flow Task to see Data Flow Designer surface.<\/li>\n<li>Here, from the SSIS Toolbox drag and drop ZS DummyData Source on the data flow designer surface.\n<div style=\"width: 492px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/dummy-data-Source\/ssis-dummy-data-source-adapter-drag.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/dummy-data-Source\/ssis-dummy-data-source-adapter-drag.png\" alt=\"SSIS ZS Dummy Data Source - Drag and Drop\" width=\"482\" height=\"120\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Dummy Data Source &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Double click on Dummy Data Source to configure it.\n<div style=\"width: 500px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-dummy-data-source-generate-fake-json-documents.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-dummy-data-source-generate-fake-json-documents.png\" alt=\"SSIS ZS Dummy Data Source - Configure\" width=\"490\" height=\"537\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Dummy Data Source &#8211; Configure<\/p><\/div><\/li>\n<li>Click on OK button to save configure setting UI.<\/li>\n<li>From the SSIS toolbox drag and drop Amazon SQS Destination on the Data flow designer surface and\u00a0single click on the Dummy Data Source, Once you see the blue arrow from the source. connect it to Amazon SQS Destination.\n<div style=\"width: 521px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-drag.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-drag.png\" alt=\"SSIS ZS Amazon SQS Destination\" width=\"511\" height=\"180\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Amazon SQS Destination<\/p><\/div><\/li>\n<li>Now double click on Amazon SQS Destination to configure it.<\/li>\n<li>In the [Connection Manager] tab select SQS connection manager we have created before it.\n<div style=\"width: 673px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-select-adapter-connection.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-select-adapter-connection.png\" alt=\"SSIS Amazon SQS Destination - Configure Connection Manager\" width=\"663\" height=\"275\" \/><\/a><p class=\"wp-caption-text\">SSIS Amazon SQS Destination &#8211; Configure Connection Manager<\/p><\/div><\/li>\n<li>Click on [Component Properties] tab and Select Target Queue from the dropdown list.\n<div style=\"width: 817px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-select-queue.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-select-queue.png\" alt=\"SSIS ZS Amazon SQS Destination - Configure Component Properties\" width=\"807\" height=\"408\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Amazon SQS Destination &#8211; Configure Component Properties<\/p><\/div><\/li>\n<li>Click on [Mappings] tab and verify mapping. Map document column from upstream to the MessageText target column.\n<div style=\"width: 655px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-select-mappings.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-select-mappings.png\" alt=\"SSIS ZS Amazon SQS Destination - Column Mappings\" width=\"645\" height=\"518\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Amazon SQS Destination &#8211; Column Mappings<\/p><\/div><\/li>\n<li>In the last, click on the OK button to save configure setting UI.<\/li>\n<li>After all, Execute the Package and verify target data by going to your AWS console under SQS service section.\n<div style=\"width: 338px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-insert-messages.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-insert-messages.png\" alt=\"Run or Execute SSIS Package\" width=\"328\" height=\"302\" \/><\/a><p class=\"wp-caption-text\">Run or Execute SSIS Package<\/p><\/div>\n<div style=\"width: 776px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/check-aws-sqs-message-verify-count-console.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/check-aws-sqs-message-verify-count-console.png\" alt=\"Verify Amazon SQS Destination\" width=\"766\" height=\"565\" \/><\/a><p class=\"wp-caption-text\">Verify Amazon SQS Destination<\/p><\/div><\/li>\n<\/ol>\n<h2>Read Data using Amazon SQS Source in SSIS<\/h2>\n<h3>Overview<\/h3>\n<p>In this tutorial, you will learn how to read data from Amazon SQS storage in SSIS using ZS SSIS Amazon SQS Source Adapter. In this SSIS we will read data. So let&#8217;s begin it.<\/p>\n<h3>Read Data from Amazon SQS<\/h3>\n<ol>\n<li>Firstly, create a new SSIS package. In BIDS\/SSDT create a new SSIS package.<\/li>\n<li>From the SSIS toolbox drag and drop Data Flow Task on the control flow designer surface.\n<div style=\"width: 470px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/drag-and-drop-data-flow-task.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/drag-and-drop-data-flow-task.png\" alt=\"SSIS Data Flow Task - Drag and Drop\" width=\"460\" height=\"155\" \/><\/a><p class=\"wp-caption-text\">SSIS Data Flow Task &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Double click on the DataFlow task to see DataFlow designer surface.<\/li>\n<li>From the SSIS toolbox drag and drop ZS Amazon SQS Source on the dataflow designer surface.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-thumbnail\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-amazon-sqs-source-drag.png\" width=\"474\" height=\"101\" \/><\/li>\n<li>Double click Amazon SQS Source to configure it.<\/li>\n<li>Select Amazon SQS Connection we have created before and select queue from the dropdown list.\n<div style=\"width: 908px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-amazon-sqs-source-preview-messages.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-amazon-sqs-source-preview-messages.png\" alt=\"SSIS Amazon SQS Source - Configure\" width=\"898\" height=\"601\" \/><\/a><p class=\"wp-caption-text\">SSIS Amazon SQS Source &#8211; Configure<\/p><\/div><\/li>\n<li>\u00a0Click on Preview button to see Data Preview and Click on\u00a0 OK button to save settings.<\/li>\n<li>From the SSIS toolbox drag and drop Trash Destination on the data flow designer surface or you can use any of our suitable <a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/ssis-destination-adapters.htm\" target=\"_blank\" rel=\"noopener\">ZS Destination Adapter.<\/a>\n<div style=\"width: 529px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ssis-trash-destination-adapter-drag.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ssis-trash-destination-adapter-drag.png\" alt=\"SSIS ZS Trash Destination - Drag and Drop\" width=\"519\" height=\"121\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Trash Destination &#8211; Drag and Drop<\/p><\/div><\/li>\n<li>Now single click on the Amazon SQS Source once you see the blue arrow from the source &#8230; connect it to Trash Destination.<\/li>\n<li>Double click on ZS Trash Destination to Configure it.\n<div style=\"width: 622px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ui-trash-destination-settings.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/trash-destination\/ui-trash-destination-settings.png\" alt=\"SSIS ZS Trash Destination - Configure\" width=\"612\" height=\"523\" \/><\/a><p class=\"wp-caption-text\">SSIS ZS Trash Destination &#8211; Configure<\/p><\/div><\/li>\n<li>Click on OK button to save Trash Destination configure setting UI.<\/li>\n<li>After all, right-click on the path and Add Data Viewer and Execute the package and verify source data in the data viewer.\n<div style=\"width: 653px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-read-messages-from-amazon-sqs-queue.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-source\/ssis-read-messages-from-amazon-sqs-queue.png\" alt=\"Run or Execute The SSIS Package\" width=\"643\" height=\"459\" \/><\/a><p class=\"wp-caption-text\">Run or Execute The SSIS Package<\/p><\/div><\/li>\n<li>After messages read from SQS Queue, the same message cannot be read again until VisibilityTimeout. By default Queue, visibility timeout is used (-1 means use default) but you can override it on the source UI.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h3>Read all messages from SQS FIFO Queue<\/h3>\n<p>If you are using Normal SQS Queue then by setting <strong>Max Rows=0<\/strong> will read all messages from your queue. However reading all messages from <a href=\"https:\/\/docs.aws.amazon.com\/AWSSimpleQueueService\/latest\/SQSDeveloperGuide\/FIFO-queues.html\" target=\"_blank\" rel=\"noopener\">FIFO Queue<\/a> is not that simple. Amazon SQS wont return more messages until you delete previously read Messages from same Message Group (identified by MessageGroupId). Due to this constraint you have to try below technique of Loop to read 10 messages until all messages Read &gt; Processed\u00a0 &gt; Deleted.<\/p>\n<p>Here is note from Amazon Documentation about maximum 10 messages limitation on FIFO Queue.<\/p>\n<pre class=\"\">When you receive a message with a message group ID, no more messages for the same message group ID are returned unless you delete the message or it becomes visible.<\/pre>\n<p><strong>Community Reference:<\/strong><\/p>\n<p><a href=\"https:\/\/stackoverflow.com\/questions\/51661834\/aws-sqs-fifo-how-to-get-more-than-10-messages-at-a-time\" target=\"_blank\" rel=\"noopener\">https:\/\/stackoverflow.com\/questions\/51661834\/aws-sqs-fifo-how-to-get-more-than-10-messages-at-a-time<\/a><\/p>\n<p>If you want to add fault tolerance then you can set Max Retry for NULL Receive like below (e.g. Setting MaxRetry=3 will try max 3 times if no message is read &#8230;. It will try every 2 seconds for 3 times before giving up to read more rows).<\/p>\n<div id=\"attachment_8723\" style=\"width: 940px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-queue-read-all-messages.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8723\" class=\"size-full wp-image-8723\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-queue-read-all-messages.png\" alt=\"Read all messages from Amazon SQS FIFO Queue\" width=\"930\" height=\"666\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-queue-read-all-messages.png 930w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-queue-read-all-messages-300x215.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-queue-read-all-messages-768x550.png 768w\" sizes=\"(max-width: 930px) 100vw, 930px\" \/><\/a><p id=\"caption-attachment-8723\" class=\"wp-caption-text\">Read all messages from Amazon SQS FIFO Queue<\/p><\/div>\n<p>&nbsp;<\/p>\n<div id=\"attachment_8724\" style=\"width: 978px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-read-process-delete-message-ssis.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8724\" class=\"size-full wp-image-8724\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-read-process-delete-message-ssis.png\" alt=\"Read , Process and Delete Amazon SQS FIFO Queue Message in SSIS Data flow\" width=\"968\" height=\"587\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-read-process-delete-message-ssis.png 968w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-read-process-delete-message-ssis-300x182.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-aws-sqs-fifo-read-process-delete-message-ssis-768x466.png 768w\" sizes=\"(max-width: 968px) 100vw, 968px\" \/><\/a><p id=\"caption-attachment-8724\" class=\"wp-caption-text\">Read , Process and Delete Amazon SQS FIFO Queue Message in SSIS Data flow<\/p><\/div>\n<p>&nbsp;<\/p>\n<h2>Delete Message from Queue using Amazon SQS Destination in SSIS<\/h2>\n<h3>Overview<\/h3>\n<p>In this tutorial, you will learn how to Delete Messages from the Queue using the ZS SSIS Amazon SQS Destination Adapter. So let\u2019s begin it.<\/p>\n<h3>Delete Message from Queue<\/h3>\n<ol>\n<li>From the SSIS toolbox drag and drop Amazon SQS Destination on the Data flow designer surface and connect it to Amazon SQS Destination.<\/li>\n<li>Now double click on Amazon SQS Destination to configure it.<\/li>\n<li>In the [Connection Manager] tab select SQS connection manager we have created before it.\n<div style=\"width: 673px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-select-adapter-connection.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/images\/amazon-sqs-destination\/ssis-amazon-sqs-destination-select-adapter-connection.png\" alt=\"Select Amazon SQS Connection\" width=\"663\" height=\"275\" \/><\/a><p class=\"wp-caption-text\">Select Amazon SQS Connection<\/p><\/div><\/li>\n<li>Click on [Component Properties] tab, Set Operation to Delete and Select Target Queue from the dropdown list.\n<div id=\"attachment_8662\" style=\"width: 731px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-sqs-destination-select-delete-operation.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8662\" class=\"wp-image-8662 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-sqs-destination-select-delete-operation.png\" alt=\"Select Delete Operation and Queue\" width=\"721\" height=\"662\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-sqs-destination-select-delete-operation.png 721w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-sqs-destination-select-delete-operation-300x275.png 300w\" sizes=\"(max-width: 721px) 100vw, 721px\" \/><\/a><p id=\"caption-attachment-8662\" class=\"wp-caption-text\">Select Delete Operation and Queue<\/p><\/div><\/li>\n<li>Click on [Column Mappings] tab and verify mapping. Map document column from upstream to the MessageText target column.\n<div id=\"attachment_8663\" style=\"width: 693px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/read-delete-message-from-aws-sqs-queue.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8663\" class=\"wp-image-8663 size-full\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/read-delete-message-from-aws-sqs-queue.png\" alt=\"Do Columns Mapping\" width=\"683\" height=\"410\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/read-delete-message-from-aws-sqs-queue.png 683w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/read-delete-message-from-aws-sqs-queue-300x180.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/a><p id=\"caption-attachment-8663\" class=\"wp-caption-text\">Do Columns Mapping<\/p><\/div><\/li>\n<li>In the last, click on the OK button to save configure setting UI.<\/li>\n<li>After all, Execute the Package and verify target data by going to your AWS console under SQS service section.<\/li>\n<\/ol>\n<h2>Purge All Messages from SQS Queue (Clear Queue)<\/h2>\n<p>There will be a time you like to clear entire queue (i.e. Delete All Messages from Queue). Amazon recently added <a href=\"https:\/\/docs.aws.amazon.com\/AWSSimpleQueueService\/latest\/APIReference\/API_PurgeQueue.html\" target=\"_blank\" rel=\"noopener\">PurgeQueue API<\/a> feature so now its possible without doing Delete message technique mentioned in previous section. ZappySys support <a href=\"https:\/\/zappysys.com\/blog\/how-to-call-amazon-aws-api-using-ssis-ec2-lambda-api-gateway-sqs\/\" target=\"_blank\" rel=\"noopener\">calling any AWS API using REST API Task<\/a> along with AWS Provider in OAuth Connection. You can use same technique to call PurgeQueue API like below.<\/p>\n<ol>\n<li>Open SSIS Package and\u00a0Drag <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-rest-api-web-service-task\/\" target=\"_blank\" rel=\"noopener\">ZS REST API Task<\/a> from Control Flow Toolbox<\/li>\n<li>Click on URL mode dropdown and change to URL from Connection.<\/li>\n<li>From COnnection Dropdown select NEW ZS-OAuth connection<\/li>\n<li>Configure OAuth connection to use <strong>Provider=Amazon AWS v4<\/strong>\n<ol>\n<li>Enter Access Key and Secret Key and click OK to save connection<\/li>\n<\/ol>\n<\/li>\n<li>Enter below URL on REST API Task (Replace Queue ID and name with your own values) &#8211; Refer to your AWS Console \/ SQS Queue Properties to get this URL\n<pre class=\"lang:default highlight:0 decode:true\">https:\/\/sqs.ENTER-REGION-HERE.amazonaws.com\/ENTER-QUEUE-ID-HERE\/ENTER-QUEUE-NAME-HERE\/?Action=PurgeQueue<\/pre>\n<p>Here is an example of Sample Queue from ZappySys Demo<\/p>\n<pre class=\"lang:default highlight:0 decode:true \">https:\/\/sqs.us-east-1.amazonaws.com\/718883169616\/zappysystest.fifo\/?Action=PurgeQueue<\/pre>\n<\/li>\n<li>Click ok to Save REST API Task<\/li>\n<\/ol>\n<div id=\"attachment_8722\" style=\"width: 1217px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-aws-rest-api-call-purge-all-messages-from-queue.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8722\" class=\"size-full wp-image-8722\" src=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-aws-rest-api-call-purge-all-messages-from-queue.png\" alt=\"How to Purge Amazon SQS Queue in SSIS (Clear Queue \/ Delete All messages using PurgeQueue REST API)\" width=\"1207\" height=\"877\" srcset=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-aws-rest-api-call-purge-all-messages-from-queue.png 1207w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-aws-rest-api-call-purge-all-messages-from-queue-300x218.png 300w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-aws-rest-api-call-purge-all-messages-from-queue-768x558.png 768w, https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/ssis-amazon-aws-rest-api-call-purge-all-messages-from-queue-1024x744.png 1024w\" sizes=\"(max-width: 1207px) 100vw, 1207px\" \/><\/a><p id=\"caption-attachment-8722\" class=\"wp-caption-text\">How to Purge Amazon SQS Queue in SSIS (Clear Queue \/ Delete All messages using PurgeQueue REST API)<\/p><\/div>\n<h2>Conclusion<\/h2>\n<p>So, In this blog, we learn\u00a0How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS. We used Amazon SQS Destination for write data and Amazon SQS Source to read data. Additionally, you can <a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/\" target=\"_blank\" rel=\"noopener\">download SSIS PowerPack here<\/a>\u00a0to try many other scenarios that are not discussed in this blog along with 70+ other components.<\/p>\n<h2>References<\/h2>\n<p>Finally, you can use the following links for more information:<\/p>\n<ul>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-sqs-source-connector\/\" target=\"_blank\" rel=\"noopener\">Amazon SQS Source<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/products\/ssis-powerpack\/ssis-amazon-sqs-destination-connector\/\" target=\"_blank\" rel=\"noopener\">Amazon SQS Destination<\/a><\/li>\n<li><a href=\"https:\/\/docs.aws.amazon.com\/AWSSimpleQueueService\/latest\/SQSDeveloperGuide\/welcome.html\" target=\"_blank\" rel=\"noopener\">Documents of Amazon SQS<\/a><\/li>\n<li>Help File:\n<ul>\n<li><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/ssis-amazon-sqs-queue-source.htm\" target=\"_blank\" rel=\"noopener\">Amazon SQS Source<\/a><\/li>\n<li><a href=\"https:\/\/zappysys.com\/onlinehelp\/ssis-powerpack\/scr\/ssis-amazon-sqs-queue-destination.htm\" target=\"_blank\" rel=\"noopener\">Amazon SQS Destination<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Introduction ZappySys provides high-performance drag and drop connectors for Amazon AWS Integration. In this post, we will see How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS using ZS Amazon SQS components. ZappySys developed many AWS related components but in this article, we will look at 2 components for Amazon SQS [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7800,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[554,553],"tags":[547,28,576,29,292,282,537,509,534,314,305,257,12,508,529],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS | ZappySys Blog<\/title>\r\n<meta name=\"description\" content=\"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS using ZappySys PowerPack components Amazon SQS Source and Amazon SQS Destination.\" \/>\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\/read-write-amazon-sqs-queue-data-ssis\/\" \/>\r\n<meta property=\"og:locale\" content=\"en_US\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS | ZappySys Blog\" \/>\r\n<meta property=\"og:description\" content=\"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS using ZappySys PowerPack components Amazon SQS Source and Amazon SQS Destination.\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/\" \/>\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=\"2019-08-19T12:17:48+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2020-02-05T15:42:23+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png\" \/>\r\n\t<meta property=\"og:image:width\" content=\"512\" \/>\r\n\t<meta property=\"og:image:height\" content=\"512\" \/>\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=\"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\/read-write-amazon-sqs-queue-data-ssis\/\",\"url\":\"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/\",\"name\":\"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS | ZappySys Blog\",\"isPartOf\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png\",\"datePublished\":\"2019-08-19T12:17:48+00:00\",\"dateModified\":\"2020-02-05T15:42:23+00:00\",\"author\":{\"@id\":\"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82\"},\"description\":\"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS using ZappySys PowerPack components Amazon SQS Source and Amazon SQS Destination.\",\"breadcrumb\":{\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#primaryimage\",\"url\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png\",\"contentUrl\":\"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png\",\"width\":512,\"height\":512},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/zappysys.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS\"}]},{\"@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":"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS | ZappySys Blog","description":"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS using ZappySys PowerPack components Amazon SQS Source and Amazon SQS Destination.","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\/read-write-amazon-sqs-queue-data-ssis\/","og_locale":"en_US","og_type":"article","og_title":"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS | ZappySys Blog","og_description":"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS using ZappySys PowerPack components Amazon SQS Source and Amazon SQS Destination.","og_url":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/","og_site_name":"ZappySys Blog","article_author":"https:\/\/www.facebook.com\/ZappySys\/","article_published_time":"2019-08-19T12:17:48+00:00","article_modified_time":"2020-02-05T15:42:23+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.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":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/","url":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/","name":"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS | ZappySys Blog","isPartOf":{"@id":"https:\/\/zappysys.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#primaryimage"},"image":{"@id":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#primaryimage"},"thumbnailUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png","datePublished":"2019-08-19T12:17:48+00:00","dateModified":"2020-02-05T15:42:23+00:00","author":{"@id":"https:\/\/zappysys.com\/blog\/#\/schema\/person\/2756c237457fbc95d82cb38962f81f82"},"description":"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS using ZappySys PowerPack components Amazon SQS Source and Amazon SQS Destination.","breadcrumb":{"@id":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#primaryimage","url":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png","contentUrl":"https:\/\/zappysys.com\/blog\/wp-content\/uploads\/2019\/08\/amazon-sqs_512.png","width":512,"height":512},{"@type":"BreadcrumbList","@id":"https:\/\/zappysys.com\/blog\/read-write-amazon-sqs-queue-data-ssis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/zappysys.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Read \/ Write \/ Delete Amazon SQS Queue data in SSIS"}]},{"@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\/7799"}],"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=7799"}],"version-history":[{"count":24,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7799\/revisions"}],"predecessor-version":[{"id":8725,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/posts\/7799\/revisions\/8725"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media\/7800"}],"wp:attachment":[{"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/media?parent=7799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/categories?post=7799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zappysys.com\/blog\/wp-json\/wp\/v2\/tags?post=7799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}