SSIS Amazon S3 JSON File Source - Visual Studio Marketplace

Read JSON files from Amazon S3 directly in SSIS Data Flow.

Ingest one or multiple JSON files from S3 using wildcard patterns, parse nested structures with path expressions, and process ZIP/GZip files in stream mode. Build scalable cloud JSON pipelines without custom script components.
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

S3 JSON Ingestion at Scale — Read single or wildcard JSON files from Amazon S3 paths
Nested Data Extraction — Use path expressions to flatten arrays and nested objects
Compressed JSON Support — Stream ZIP/GZip sources directly without temp extraction
Quality & Error Controls — Configure date-time parsing and redirect bad records
Design-Time Confidence — Preview output before execution for faster package development

📸 Visual Overview & Setup

1. Drag Amazon S3 JSON Source 🔍 View Full Size	2. Create S3 Connection Manager 🔍 View Full Size	3. Select JSON File(s) in Browser 🔍 View Full Size
4. Read Compressed JSON 🔍 View Full Size	5. DateTime Parsing Options 🔍 View Full Size	6. Design-Time Data Preview 🔍 View Full Size

🔧 Key Features

Read JSON from Amazon S3 with single/multi-file wildcard support
Path-expression extraction for nested arrays/objects
ZIP/GZip streaming support for compressed files
Date-time handling and error redirection controls
Design-time preview for faster schema validation

💡 Common Use Cases

S3 JSON Feeds: Load partner or app event JSON files from S3 into data warehouse staging.
Nested JSON ETL: Flatten multi-level payloads for relational analytics.
Compressed Intake: Process ZIP/GZip JSON files directly in nightly pipelines.
Controlled Imports: Route malformed records while keeping good data flowing.

🎯 Summary

SSIS Amazon S3 JSON File Source simplifies cloud JSON ingestion with wildcard loading, nested extraction, compressed-file support, and design-time preview. It helps teams build reliable, no-code production ETL pipelines on top of Amazon S3.

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 S3 JSON File Source

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