Included in SSIS PowerPack

SSIS Amazon SQS Destination

Write/delete data from Amazon SQS using SSIS.

Amazon SQS Destination can be used to write/delete data from Amazon SQS (Simple Queue Service) using SSIS.

Download Free Trial Buy Now

The trial includes Amazon SQS Destination and every other PowerPack component

Help & Docs
Amazon SQS Destination in SSDT
Configure Amazon SQS Destination Connection
Write/delete data from Amazon SQS using SSISExplore the UI →

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Amazon SQS Destination can do

Amazon SQS Destination can be used to write/delete data from Amazon SQS (Simple Queue Service) using SSIS.

Bulk write messages

Write messages to an Amazon SQS queue in bulk from any Data Flow source.

  • Map an upstream column to the MessageText target column
  • Pick the target queue from a dropdown (QueueName)

Read / write SQS tutorial

Insert, delete & more

Choose the action to perform on the queue with the Operation property.

  • Insert, Delete, UpdateVisibility or Reload

Component properties

Delete processed messages

Delete messages from the queue using the MessageId and PopReceipt mapped on the Mappings screen.

  • Read, process and delete messages in one Data Flow

Delete message tutorial

Visibility timeout

Set the message visibility timeout in seconds.

  • VisibilityTimeout: -1 uses the queue’s default setting

Component properties

Error output

Redirect bad rows to the error output with the exact reason of the error.

  • By default the component fails on any data error or truncation

Component help

AWS connection

Connect with the Amazon Storage Connection Manager set to the SQS service.

  • Access key, secret key and region
  • Temporary token or default (IAM Role) credentials

Connection Manager help

Logging control

Control how much information is logged during package execution.

  • LoggingMode: Normal, Medium, Detailed or Debugging
  • PrefixTimestamp adds a timestamp to log messages

Component properties

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

See all features
  • Write messages to Amazon SQS in bulk
  • Perform Insert, Delete, Update Visibility and Reload actions for SQS
  • Delete messages from the queue using MessageId and PopReceipt (mapped on the Mapping screen)
  • Select the target queue from a dropdown
  • Message visibility timeout setting (or use the queue default)
  • Error output to redirect bad rows with the error reason
  • Key-based, temporary token or default (IAM Role) credentials on the AWS connection
  • Logging modes (Normal, Medium, Detailed, Debugging) with optional timestamp prefix

  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Key steps from the Amazon SQS Destination page and help file, with the screens you will see in SSDT.

Connect to Amazon SQS.

Right-click the Connection Managers panel, choose New Connection and pick ZS-AWS-STORAGE. Set the service type to SQS, enter your Access Key, Secret Key and Region, and click Test Connection.

In the destination, select this connection on the Connection Manager tab.

Configure Amazon SQS Destination Connection

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Amazon SQS Destination product page. Step through them, or open any shot at full size.

Amazon SQS Destination – Connection Manager

Create a ZS-AWS-STORAGE connection with service type SQS, your Access Key, Secret Key and Region.

Articles

Worked examples that use Amazon SQS Destination.

GuideHow to Read / Write / Delete Amazon SQS Queue data in SSISWrite messages with the SQS Destination, read them with the SQS Source (including FIFO queues), delete processed messages and purge a queue.zappysys.com blogRead articleGuideHow to call Amazon AWS API using SSIS (EC2, Lambda, API Gateway, SQS)Call any AWS API, including SQS actions such as creating or purging a queue, with the REST API Task.zappysys.com blogRead articleCollectionAll Amazon SQS Destination articlesMore tutorials from the ZappySys blog.zappysys.com blogBrowse all articles

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop Amazon SQS Destination on the canvas.

What is Amazon SQS Destination?

Amazon SQS Destination can be used to write or delete messages in Amazon SQS (Simple Queue Service) from an SSIS Data Flow. It writes messages in bulk and can also delete messages, update their visibility or reload them.

Which operations does it support?

Set Operation to Insert, Delete, UpdateVisibility or Reload, and pick the target queue in QueueName.

How do I write rows as SQS messages?

Connect any source to the destination and, on the Mappings tab, map the column that holds the message body (for example a JSON document) to MessageText. Run the package and check the queue in the AWS console.

How do I delete messages after processing them?

Read the messages with Amazon SQS Source, process them, then send them to an Amazon SQS Destination with Operation set to Delete. See How to Read / Write / Delete Amazon SQS Queue data in SSIS.

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag Amazon SQS Destination onto the Data Flow.

Write/delete data from Amazon SQS using SSIS.

  • Data Flow Destination in SSISAmazon SQS Destination appears in the toolbox after you install PowerPack.
  • Fully functional 30-day trialSSIS PowerPack, running in your environment.
  • Live supportHelp during your trial and after purchase.
Download Free TrialView Pricing

Open Help FileBrowse all SSIS PowerPack tasks

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

+1-800-444-5602Contact supportSSIS PowerPack overview

1 / 6