100+ high-performance SSIS connectors & tasks — integrate REST APIs, cloud platforms, databases, and files without writing code.
ZappySys SSIS PowerPack is a drag-and-drop component suite for SQL Server Integration Services.
Connect to JSON, XML, CSV, Excel, REST/SOAP APIs, Azure, AWS, Salesforce, MongoDB, Redshift, SharePoint, Dynamics 365, and dozens more.
Includes pre-configured API Connectors, OAuth connection managers, and built-in pagination/retry logic.
Free for development inside Visual Studio. Deploy on-premises or in Azure Data Factory (Azure-SSIS IR).
Compatibility: SQL Server 2012–2025+ • Visual Studio 2012–2026 • 32/64-bit • Azure Data Factory / Azure-SSIS IR
📦 What's Inside
The SSIS PowerPack includes 100+ components across these categories. Every component is drag-and-drop with a visual UI — no scripting required.
|
🔗 REST API & SOAP / Web Services
- JSON Source & Destination (File / REST API)
- XML Source & Destination (File / SOAP API)
- REST API Web Service Task
- Download File Task (HTTP/HTTPS)
- Salesforce API Task
|
🔌 Pre-Configured API Connectors
- Salesforce, SharePoint, Dynamics 365
- HubSpot, Jira, Zendesk, Shopify
- Google Analytics, Google Ads, Facebook
- Amazon MWS, Office 365, and 50+ more
- API Source & API Destination components
|
|
📄 File Formats (JSON, XML, CSV, Excel)
- Export JSON / XML / CSV / Excel Tasks
- CSV Source (File / Web API) & Destination
- Excel Source & Destination (.xlsx without Excel)
- JSON / XML / CSV Parser & Generator Transforms
|
☁️ Microsoft Azure
- Azure Blob Storage Task & Source/Dest (JSON, XML, CSV)
- Azure Table Storage Source & Destination
- Azure Queue Storage Source & Destination
- Azure Data Factory / Azure-SSIS IR deployment
|
|
🌐 Amazon AWS
- Amazon S3 Task & Source/Dest (JSON, XML, CSV)
- Amazon Redshift Data Transfer, ExecuteSQL, Cluster Management
- Amazon SQS Queue Source & Destination
- Amazon DynamoDB ExecuteSQL Task
|
🗄️ Databases & CRM
- MongoDB Source, Destination & ExecuteSQL
- PostgreSQL Source, Destination & ExecuteSQL
- Salesforce Source & Destination
- Dynamics CRM Source & Destination
|
|
📁 Secure FTP / SFTP
- SFTP Task (FTP, FTPS, Secure FTP)
- Secure FTP Source/Dest for JSON, XML, CSV
|
🛠️ Productivity & Automation
- Advanced File System Task (bulk copy/move/delete/rename)
- Upsert Destination (bulk insert + update)
- Send HTML Email Task, Report Generator (SSRS)
- Logging Task (FREE), Timer Task, Validation Task
|
⚡ Why Choose SSIS PowerPack
|
Zero Coding Required
Every component has a visual UI — drag from the toolbox, configure with point-and-click, and run. No Script Tasks or custom code needed.
|
Built-in API Intelligence
OAuth 1.0/2.0 connection managers, automatic pagination, retry on failure, and response caching — so you spend time on data, not plumbing.
|
|
Free for Development
Full functionality inside Visual Studio at no cost. No license key needed while developing and testing in SSDT / BIDS. Includes FREE components that remain free even in production.
|
Cloud-Ready Deployment
Run packages on-premises (SQL Server 2012–2025+) or in the cloud with Azure Data Factory and Azure-SSIS Integration Runtime — same packages, no rewrite.
|
📊 Editions at a Glance
| Edition |
Components |
Highlights |
| FREE |
5+ |
Logging Task, Timer Task, Dummy Source, Trash Destination, HTML Table Source — free forever, even in production. |
| Standard |
40+ |
JSON, XML, CSV, Excel, FTP, Azure, AWS, Email, File System, and more core connectors. |
| Professional |
70+ |
Standard + MongoDB, PostgreSQL, Salesforce, Dynamics CRM, Redshift, and OAuth providers. |
| Enterprise |
100+ |
Professional + API Source/Destination with 50+ pre-configured API Connectors and custom connector support. |
💬 What Customers Say
|
"We have been using ZappySys for our data warehouse SSIS ETL for a couple of years and we LOVE the product so much. Support response is fast and get the right answer all the time."
— Kevin Chen, Berricle
|
"The functionality of the REST source is very powerful, and it is in fact the only thing I have found that I am able to use — I have tried a few other components from major vendors also."
— Jes Kirkup, KTC
|
|
"ZappySys SSIS PowerPack is a sensational product, with a great support team. In my book, this makes it stand above the other products in the marketplace."
— Maz Dunic, Save the Children Australia
|
"The tools are more than just drag and drop, point and click. They include all of what you need to see what is really going on under the hood and tools for troubleshooting."
— Joel Conner, Synchronous Customers
|
Trusted by 3000+ Teams Worldwide
- Rapid Update Cycle: Regular releases with new connectors, improvements, and compatibility updates.
- Expert Technical Support: Direct access to engineers via phone, email, live chat, and remote screen-share sessions.
- 30-Day Money Back Guarantee: Risk-free evaluation with full refund if not satisfied.
|
Read reviews on Capterra →
|
Ready to Build Robust ETL Pipelines?
Download the full SSIS PowerPack — 100+ connectors & tasks. Free for development inside Visual Studio.
30-day trial • No license needed for development • FREE components included
| |
