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).
📦 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
|
🔌 Pre-Configured API Connectors
|
|
📄 File Formats (JSON, XML, CSV, Excel)
|
☁️ Microsoft Azure
|
|
🌐 Amazon AWS
|
🗄️ Databases & CRM
|
|
📁 Secure FTP / SFTP
|
🛠️ Productivity & Automation
|
⚡ 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
|
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