Included in SSIS PowerPack

SSIS Amazon SQS Source

Read messages from Amazon AWS SQS using SSIS.

Amazon SQS Source can be used to read messages from Amazon AWS SQS (Simple Queue Service) using SSIS.

The trial includes Amazon SQS Source and every other PowerPack component

Amazon SQS Source in SSDT
Amazon SQS Source - Create new connection
Read messages from Amazon AWS 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 Source can do

Amazon SQS Source can be used to read messages from Amazon AWS SQS (Simple Queue Service) using SSIS.

Bulk read messages

Read Amazon SQS messages in bulk inside the SSIS Data Flow.

  • Pick the queue from a dropdown (QueueName)
  • Data preview at design time

Read / write SQS tutorial

FIFO & normal queues

Full support for FIFO queues along with normal queues.

  • Read, process and delete FIFO messages in a loop until all are read

Read all FIFO messages

Read all messages

Keep fetching until the row limit is reached or the queue is empty.

  • MaxRows=0 reads all messages
  • MaxRetryOnNullMessageReceive retries on empty receives

Component properties

Visibility timeout

Hide messages from other readers for a set time after you read them.

  • VisibilityTimeout in seconds; -1 uses the queue default

Component properties

Message attributes

Read message attributes into separate output columns.

  • AttributeNames with data types, e.g. MyProp1=string,MyProp2=int
  • OutputAllAttributes adds an All_Attributes JSON column

Component properties

Local time & error output

Adjust UTC dates to local time and capture bad rows.

  • OutputDateAsLocalTime
  • Redirect bad rows to the error output with the error reason

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

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
  • Read Amazon SQS messages in bulk
  • Visibility timeout (hide messages from others for a certain time after you read them)
  • Full support for FIFO queues along with normal queues
  • Data preview and max rows
  • Read all messages from the queue (Max Rows=0 with Max Retry for NULL)
  • Read message attributes in separate output columns, or all attributes as JSON
  • Adjust UTC datetime to local time
  • 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 Source page and help file, with the screens you will see in SSDT.

Amazon SQS Source – Create new connection

Double-click ZS Amazon SQS Source and click New next to the connection. Set the service type to SQS, enter your Access Key and Secret Key and click Test Connection.

Amazon SQS Source - Create new connection

Inside the UI

Key settings, as they appear in SSDT.

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

Amazon SQS Source – Create new connection

Create the AWS connection with service type SQS, your Access Key and Secret Key.

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 Source on the canvas.

What is Amazon SQS Source?

Amazon SQS Source can be used to read messages from Amazon SQS (Simple Queue Service) in bulk inside an SSIS Data Flow. It supports normal and FIFO queues, visibility timeout, message attributes and data preview.

How do I read all messages in the queue?

Set MaxRows to 0 so the source keeps fetching until the queue returns no more messages, and set MaxRetryOnNullMessageReceive to retry a few times on an empty receive. For FIFO queues, delete messages as you process them, because SQS will not return more messages from the same message group until earlier ones are deleted. See the SQS tutorial.

Why can’t I read the same message twice?

After a message is read it stays hidden until its visibility timeout expires. VisibilityTimeout is in seconds; -1 uses the queue default and 0 allows the same message to be read again without waiting.

Can I read message attributes?

Yes. Turn on FetchAttributes and list attributes in AttributeNames (e.g. MyProp1=string,MyProp2=int) to get one Attr_ column per attribute, or set OutputAllAttributes to get an All_Attributes JSON column.

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 Source onto the Data Flow.

Read messages from Amazon AWS SQS using SSIS.

  • Data Flow Source in SSISAmazon SQS Source 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.

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 / 9