Skip to content
| Marketplace
Sign in
Visual Studio>Controls>SSIS Amazon SQS Destination Connector
SSIS Amazon SQS Destination Connector

SSIS Amazon SQS Destination Connector

ZappySys

|
96 clicks
| (0) | Free Trial
Publish messages to Amazon SQS from SSIS with drag-and-drop mapping and no scripting. Configure queue connection, map payload fields, run bulk message inserts, and verify delivery in AWS console workflows. Part of ZappySys SSIS PowerPack.
Get Started

Extract Amazon SQS queue data from SSIS using destination write operations for queue-driven integrations.

Send messages to AWS SQS queues from any SSIS source with configurable mappings, secure connection options, and batch-friendly flow design. Build event-driven pipelines that publish transformed records to SQS for downstream processing services.
Part of ZappySys SSIS PowerPack.

Recommended starting point
View Setup Guide & Get Started →
See features, UI & examples →
Pro Tip: The Visual Studio download installs a basic extension. Use the guide above to install and run the full SSIS PowerPack (all connectors & UI).
Compatibility: SQL Server 2012–2025+ (32/64-bit) | Azure Data Factory / Azure-SSIS IR Ready

⚡ Key Benefits

  • Queue Publishing from SSIS — Push transformed data to SQS directly from Data Flow
  • Flexible Message Mapping — Map columns to message body and attributes for downstream consumers
  • Bulk-Friendly Operations — Process high message volumes in ETL-style batch execution
  • AWS Validation Workflow — Verify delivery and message counts from AWS console checks
  • Secure Connection Setup — Configure AWS credentials and connection manager options in UI

📸 Visual Overview & Setup

1. Configure SQS Destination Connection
Configure SSIS Amazon SQS destination connection
🔍 View Full Size
2. Select Queue & Component Options
Select SQS queue and configure component tab
🔍 View Full Size
3. Configure Column Mappings
Configure SSIS Amazon SQS destination mappings
🔍 View Full Size
4. Insert Messages Execution
Execute SSIS Amazon SQS destination and insert messages
🔍 View Full Size
5. Verify Records in AWS Console
Verify SQS message count in AWS console
🔍 View Full Size
6. Full Settings UI
SSIS Amazon SQS destination full settings UI
🔍 View Full Size

🔧 Key Features

  • Bulk message publishing to Amazon SQS queues
  • Insert/Upsert-style mapping patterns for queue message body construction
  • Advanced mapping tab for attributes and payload shaping
  • AWS queue verification workflow support
  • Works with SQL Server, PostgreSQL, Redshift and other SSIS sources

💡 Common Use Cases

  • Event-Driven ETL: Publish transformed records as queue messages for downstream microservices.
  • Decoupled Integrations: Buffer outbound data with SQS between producer and consumer systems.
  • Batch Notification Pipelines: Send per-record notifications after warehouse processing.
  • Cloud Workflow Triggers: Feed Lambda / serverless consumers through SQS message dispatch.

🎯 Summary

SSIS Amazon SQS Destination provides a straightforward way to publish queue messages at ETL scale. It combines connection setup, mapping controls, and verification steps in one SSIS-native component for reliable cloud messaging workflows.

Trusted by Developers & IT Teams Worldwide

  • Built for SSIS Workflows: Purpose-built for high-performance ETL and complex integration scenarios.
  • Expert Technical Support: Direct access to engineers via email and remote screen-share sessions.
  • Proven Enterprise Scale: Trusted by 3000+ teams across 90+ countries, including Fortune 500.
SSIS PowerPack
Includes SSIS Amazon SQS Destination
Capterra Rating
Read reviews on Capterra →

Start Automating Workflows with SSIS PowerPack

Includes connectors for APIs, databases & cloud apps. Build robust ETL workflows without custom scripting.

Download SSIS PowerPack (Free Trial)

Full functionality is FREE for development within Visual Studio

  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2026 Microsoft