SSIS Azure Blob Storage task - Visual Studio Marketplace

Automate Azure Blob Storage operations in SSIS with a single drag-and-drop task.

Perform upload, download, copy, move, rename, delete, and metadata/content-type operations on blobs and containers. Configure actions visually, apply filters, and manage cloud file workflows without writing custom scripts.
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

30+ Azure Operations — Manage blobs/containers with upload, download, delete, copy, and move actions
No-Code Cloud File Automation — Configure workflows in SSIS UI instead of scripting
Metadata & Content Control — Set blob metadata and content type during transfer operations
Flexible Filtering — Process targeted files using wildcard and rule-based filters
Production ETL Ready — Integrate storage operations into scheduled SSIS pipelines

📸 Visual Overview & Setup

1. Drag Azure Storage Task 🔍 View Full Size	2. Create Storage Connection 🔍 View Full Size	3. Configure Connection Details 🔍 View Full Size
4. Task Action Settings 🔍 View Full Size	5. Set Metadata Values 🔍 View Full Size	6. Execute and Check Log 🔍 View Full Size

🔧 Key Features

Upload, download, copy, move, rename, and delete blobs
Container and folder-level operations in one task
Metadata and content-type management support
Filter files by wildcard patterns and criteria
Reusable Azure Storage connection manager integration

💡 Common Use Cases

Cloud Staging: Upload daily extracts from on-prem sources to Azure Blob containers.
Inbound Processing: Download partner files from Blob and route them into ETL pipelines.
Storage Hygiene: Delete/archive old blobs based on retention workflow rules.
Metadata Automation: Stamp uploaded files with metadata for downstream discovery.

🎯 Summary

SSIS Azure Blob Storage Task simplifies cloud file operations by bringing 30+ blob actions into a single SSIS-native interface. Teams can orchestrate upload/download and metadata workflows reliably without custom code.

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 Azure Blob Storage Task

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