# Page 2 | ZappySys SSIS PowerPack Reviews 2026. Verified Reviews, Pros & Cons | Capterra

> Page 2 - Is ZappySys SSIS PowerPack the right Integration solution for you? Explore 107 verified user reviews from people in industries like yours to make a confident choice.

Source: https://www.capterra.com/p/170286/SSIS-PowerPack/reviews

---

ZappySys SSIS PowerPack

4.8 (107)

[View alternatives](https://www.capterra.com/p/170286/SSIS-PowerPack/alternatives/)

Provider data verified by our Software Research team, and reviews moderated by our Reviews Verification team. [Learn more](https://www.capterra.com/our-story/)

* * *

Last updated March 13th, 2026

# Page 2 - Reviews of ZappySys SSIS PowerPack

## Showing most helpful reviews

Showing 26-50 of 107 Reviews

Sort by:

Most Helpful

Rating

Company Size

Reviewer's Role

Length of Use

Frequency of Use

GR

Gary R.  
Sr. Analyst II  
Government Administration  
Used the software for: 2+ years

### "Very supportive of Zappysys SSIS Power Pack"

December 9, 2024

5.0

We originally purchased the Zappy SSIS PowerPack JUST to get Excel connectors that worked easier and supported multiple versions of Excel at the same time. Our use has grown to include all ETL processes from over 23 Virtual Machines (database to database, cloud to database, database to cloud...even .txt to .txt to support data transfer from one "ancient" system to another... ;-).

Pros

The Powerpack adds SO much functionality to SSIS...especially in the number and variety of data connectors to almost every endpoint imaginable. Zappy has thought out every combination and permutation needed for connectors to REST/Curl interfaces as well as all popular endpoints.

Cons

Only that there is SO much flexibility...lol. The Zappy online help is really good.

Review Source

SM

Stacy M.  
Sr Systems Admin  
Consumer Services  
Used the software for: 2+ years

### "Essential Tools for Integration Services"

April 3, 2025

5.0

Pros

Has the best interface for calling APIs, Advanced file systems tasks are a game changer!

Cons

No PGP encryption/decryption task, need a license for each server

Review Source

Response from ZappySys

July 19, 2025

Thank you, Stacy, for the 10/10 recommendation and your continued trust over the years! We're thrilled to hear that the API interface and advanced file system tasks have made a strong impact. We appreciate your feedback on PGP support and licensing — both are noted and will be reviewed for future improvements. Thanks again for being a valued user!

TG

Tom G.  
BI Consultant  
Government Administration  
Used the software for: 2+ years

### "handy features to be used within SSIS - good helpdesk in case of any problems"

March 26, 2025

5.0

Pros

handy features to be used within SSIS - good helpdesk in case of any problems

Cons

no cons for the moment. working like a charm...

Review Source

KA

Kiran A.  
Database Architect  
Consumer Services  
Used the software for: 2+ years

### "Powerful platform"

March 12, 2025

4.0

Pros

This is a very powerful platform for API services

Cons

Need more documentation as there are many ZS components.

Review Source

BAB

BALA AMUTHAN B.  
Database Admin  
Computer Hardware  
Used the software for: 1-2 years

### "Database Admin"

December 11, 2024

5.0

We are using for Datawarehouse connection. it is very comfortable and quick to fetch records from MongoDB

Pros

It is user friendly . We met our requirements using Powerbock for connect to database

Cons

Looking to support for more database environment and cloud

Review Source

RR

Rick R.  
Data Application Specialist  
Electrical/Electronic Manufacturing  
Used the software for: I used a free trial

### "Good alternative to more expensive options"

December 12, 2024

5.0

Good feedback during our trial. Easy to set up. Performance is good.

Pros

Not very difficult to set up. Allows us to connect to our data lake without writing a custom api.

Cons

The documentation on setting up the JDBC driver on the gateway server isn't clear. But it wasn't terrible to figure out.

Reason for choosing ZappySys SSIS PowerPack

We are initially going to start with Precog since more development work was done with them. ZappySys came in later as an alternative. We are still considering switching to ZappySys, but a decision has not been made yet.

Review Source

MS

Mark S.  
Data Engineer  
Glass, Ceramics & Concrete  
Used the software for: 2+ years

### "Zappy Feedback"

November 20, 2024

4.0

Pros

the variety of tools for data processing and extraction

Cons

Some of the fields in the tools are somewhat confusing and do not provide any direct information about what they are responsible for

Review Source

Response from ZappySys

November 28, 2024

Thank you very much for taking the time to write this review. We would love to hear from you about what part of the UI was unclear and difficult to understand. We are constantly improving our product and documentation. Feel free to send your feature request directly to our support team (via ticket or live chat), and it gets registered in our feature requests database. We carefully review every piece of feedback and add it to our product.

MS

Manish S.  
Data Warehouse and BI Consultant  
Banking  
Used the software for: 2+ years

### "SSIS Feature Pack - Zappysys "

February 14, 2025

5.0

Excellent. It helped me solve multiple issues for my client

Pros

Versatility and options of tha package makes development very easy.

Cons

Nothing. I hope the team introduces more options in the future.

Alternatives considered

[SSIS Data Flow Components](https://www.capterra.com/p/196326/SSIS-Data-Flow-Components/)[SSIS Integration Toolkit](https://www.capterra.com/p/265855/SSIS-Integration-Toolkit/)[CozyRoc SSIS+ Components Suite](https://www.capterra.com/p/111875/CozyRoc-SSIS-1-7-Library/)

Reason for choosing ZappySys SSIS PowerPack

It had all the components for present and future use. Also, it was value for money

Review Source

SD

Shlomi D.  
integration  
Non-Profit Organization Management  
Used the software for: Less than 6 months

### "Power Pack"

October 23, 2024

5.0

It is a good product.It is satisfy my need

Pros

It is a good product. It is satisfy my need

Cons

N/A. There is nothing in particular that I did not like.

Review Source

Response from ZappySys

November 28, 2024

Shlomi, Thank you for rating our product. We are happy to hear that you like our product.

EC

Edmond C.  
IT Business Analysis  
Airlines/Aviation  
Used the software for: I used a free trial

### "Wonderful tools for collect data from API"

November 5, 2024

5.0

good, cost-effective way to get data from various way

Pros

good fixability on various connection in a reasonable cost

Cons

it is a little hard to do the configuration.

Review Source

Response from ZappySys

November 28, 2024

Thank you, Edmond, for your review. We are glad you are finding a good ROI from our product. We are constantly working to simplify things. Feel free to send a specific feature request to our support team so we can review it and add it to the product. Every feedback is vital for us.

DW

David W.  
Senior Business Analyst  
Medical Devices  
Used the software for: 1-2 years

### "Data distribution enabler."

June 6, 2024

5.0

Pros

ZappySys has enabled all of the tasks we have envisioned. My personal SSIS experience was old and minimal. ZappySys was able to assist in implementation of their tools plus train/assist with SSIS training/development.

Cons

I had some problems with the initial implementation, but that was due to my overall inexperience with SSIS and Visual Studio. ZappySys was able to assist with my roll-out.

Alternatives considered

[CozyRoc SSIS+ Components Suite](https://www.capterra.com/p/111875/CozyRoc-SSIS-1-7-Library/)

Reason for choosing ZappySys SSIS PowerPack

Packages were comparable. The decision was due to price and support.

Review Source

AL

Alexander L.  
System Analyst  
Health, Wellness and Fitness  
Used the software for: 6-12 months

### "Great simplification of integration development process"

June 20, 2024

5.0

Great choice for ETL development, solo developer will fully repay price of SSIS Power Pack in a matter of months with own time saved.

Pros

Support, they are really into helping to solve your problem. not just to fix own bugs. A lot of guidelines and pretty good documentation on all provided features.

Cons

A bit tricky process of upgrading to higher level of subscription.

Review Source

Response from ZappySys

July 11, 2024

Thank you very much for your review. We are happy to hear that you got a good ROI from the SSIS PowerPack purchase.

VR

Verified Reviewer  
IT Director  
Government Administration  
Used the software for: 2+ years

### "Swiss army knife for ETL."

November 25, 2022

4.0

Part of my career has been built on this tool because I was able to finish projects substantially faster with it than done any other way.

Pros

\- API source and target adapters stand out the most because we can now take our data in and out of cloud services where there hasn't been a vendor making a special ODBC driver to interact with their service.- Effortless point and click configuration for 80%+ of the product.

Cons

\- Some features are still rough. The Excel source adapter needs further enhancement to loop through worksheets and functions absent that is present in the CSV adapter.

Alternatives considered

[CozyRoc SSIS+ Components Suite](https://www.capterra.com/p/111875/CozyRoc-SSIS-1-7-Library/)

Reason for choosing ZappySys SSIS PowerPack

The API and JSON capability and how many checkboxes that the company tries to make it point and click simple. There are products that I've integrated with that isn't listed in Capterra.

Review Source

Response from ZappySys

December 1, 2022

Thank you so much for taking the time to review our product. We are happy to hear that you considered ZappySys and not other competitor products due to the flexibility / ease of use offered in our products. We love to get more feedback on Excel Connection feature you mentioned. Would you mind sharing what can be improved there? Excel Connection supports wildcard to read from many files if that's what you mean (e.g. c:\\files\\data\_\*.xlsx ?

JC

Jaycee C.  
BI Mgr  
Consumer Goods  
Used the software for: 2+ years

### "A responsive and capable company."

March 20, 2023

4.0

Very good value for the expense. Fairly straightforward license registations and renewals.

Pros

Developers have the primary task of converting business logic into valuable data solutions. ZappySys removes the additional challenge of long hand coding various integration sources - and has a team dedicated to handling this aspect of the value chain.

Cons

(1) The online documentation is sometimes incomplete. That said, their technical support staff are capable and responsive. (2) Keeping the licensed Production server and Dev machines in sync has not been a challenge as yet, however, you may want to implement an enforced policy to do this on an annual basis to ensure that existing production jobs are not impacted. New revisions are not formally stated to be 100% backward compatible, so keep your revisions up to date.

Review Source

Response from ZappySys

May 19, 2023

Thank you very much for this detailed review. Just to address your concern, we always strive to keep our product 100% backward compatible but in very rare circumstances we have to introduce breaking changes which we clearly note in the product release notes. If you ever notice our changes are breaking the existing jobs and we did not mention them in the Release notes then please contact us via our support channel. We assure you that every such incident will be addressed. Regarding online documentation updates - we are aware of this already and working on it to get better with every iteration.

VR

Verified Reviewer  
IT Project Manager  
Computer Software  
Used the software for: 2+ years

### "SSIS Powerpack Professional Edition boost SSIS development"

May 17, 2023

5.0

Pros

It's a robust and complete solution do add functionalities to SSIS Integration Services packages development,.

Cons

i have no cons at the moment .............

Review Source

Response from ZappySys

May 19, 2023

Thank you for the time to review our product. We are happy to hear that our product is working well for you. Feel free to reach our team if you have any questions during your project.

MM

Mark M.  
Data Architect  
Mechanical or Industrial Engineering  
Used the software for: 2+ years

### "Excellent product - has saved untold hours building custom applications"

December 15, 2020

5.0

Data integrations and warehousing. Ability to pull data via DBA-friendly tool such as SSIS rather than .NET developer creating a new service to pull data every time we turn around.

Pros

JSON/API tasks and data flows, Advance Filesystem Tasks, SFTP components

Cons

Occasional problems when using new components for the first time - usually resolved with a new release of the software. Support is very communicative and helpful though.

Alternatives considered

[CozyRoc SSIS+ Components Suite](https://www.capterra.com/p/111875/CozyRoc-SSIS-1-7-Library/)[SolarWinds Task Factory](https://www.capterra.com/p/178934/Task-Factory/)

Reason for choosing ZappySys SSIS PowerPack

ZappySys contained all the components we needed at the time. Would love it if you guys would provide a SharePoint Source and Destination like Task Factory (then we could consolidate tools).

Review Source

Response from ZappySys

December 18, 2020

Thank you very much for taking time to share your experience with our product. We are happy to hear that our JSON / API / SFTP and other tasks saving you time and cost. We have plans to add SharePoint Source / Destination in future (No ETA yet) but for now you can use our Generic JSON Source with OData Settings as described in our blog post here. https://zappysys.com/blog/sharepoint-365-rest-api-ssis-read-list-write-create/ Feel free to contact our support if you have more questions.

PA

Philippe A.  
Solution Architect Sr.  
Information Technology and Services  
Used the software for: 1-2 years

### "SSIS PowerPack to solve data integration requirements"

November 29, 2021

5.0

I have been using a small subset of PowerPack but what it does it does it very well. Set-it up, deploy it and forget about it.

Pros

PowerPack had a collection of components that I could only find here. It allowed me to extend SSIS and automate a number of web and API data integrations.

Cons

I do not think it is the product fault but sometimes, setting-up API powered data integrations is difficult, at least for me.

Alternatives considered

[CozyRoc SSIS+ Components Suite](https://www.capterra.com/p/111875/CozyRoc-SSIS-1-7-Library/)

Reason for choosing ZappySys SSIS PowerPack

API management

Review Source

Response from ZappySys

March 16, 2022

Philippe, Thank you very much for taking time to write this review and choosing ZappySys to automate your ETL needs. Your feedback is well noted and we are constantly improving to make this easy based on user input. Do not hesitate to reach our support if you have any question(s) or feedback.

OJ

Olvy J.  
Director  
Utilities  
Used the software for: 1-2 years

### "Great product and great support when you need it"

March 3, 2023

5.0

Primarily used for ETL from WEB service, SQL, csv files sources with SSIS packages that run hourly 24x7.

Pros

Been using ZappySys for about a year to save development time/cost on a ETL project with a short implementation time, our SSIS packages implemented with ZappySys components have been trouble-free.

Cons

Some component configurations are not intuitive, but once figured out it works great

Reason for choosing ZappySys SSIS PowerPack

Short project timeline

Review Source

Response from ZappySys

May 19, 2023

Thank you very much for taking the time to write this review. We are glad to hear that our product is helping you achieve better API Integration / CSV parsing. Feel free to contact us if you have any feedback or features you like to see in the product.

UL

Ulises L.  
Data Engineer  
Financial Services  
Used the software for: 2+ years

### "Effective, performant, flexible integration tool with excellent support and on-line resources"

July 22, 2022

5.0

A bit of a learning curve, but once you are through that, it is a major time saver.

Pros

Comprehensive, flexible tool to meet most integration needs. Great complement to SSIS. Support team is quick to address issues when they come up.

Cons

None worth mentioning. Some might find it a little challenging to use. You will be well-served to have Fiddler and Postman handy.

Review Source

BP

Ben P.  
Database Administrator/SQL Analyst  
  
Used the software for:

### "It's been okay overall, the software works well for what it does."

May 25, 2018

3.0

The main benefit I get from the product is dealing with the intricacies of connecting to a REST API that requires OAUTH2 authentication.

Pros

It definitely takes care of the intricacies of OAUTH2, and the fact that zappysys provides a callback url to use is very helpful.

Cons

The fact that JSON Integration package includes the JSON Source Connector, but not the REST API/OAUTH connection to go with it is highly disappointing. It feels as if they are doing that just to get customers to spend the extra dollars, that was probably the most disappointing part of my experience. I also notice the custom token prefix setting for the REST API/OAUTH connection doesn't really work.

Review Source

Response from ZappySys

June 1, 2018

Thank you for taking time to write this review. Based on the description looks like you were upset on mainly two issues so we would like to clarify in case there was some confusion. #1. Regarding price / missing oauth feature in JSON Pack: We always included REST OAuth / HTTP connections part of our JSON Integration Pack so no need to buy the full pack if JSON pack meets your need to call REST API services. See here for details https://zappysys.com/products/ssis-powerpack/ssis-json-integration-pack/ #2. Regarding token prefix setting issue: We looked at your communication with our support staff but there is no mention about this issue. Let us know if you filed a ticket regarding this but we have not acted upon it. Every BUG report / product issue is carefully analyzed by our team so we assure you that your efforts won¿t be wasted. Please do not hesitate to contact our support team if you have more questions. Best Regards, ZappySys Team

DB

David B.  
LEAD IT ENGINEER  
Telecommunications  
Used the software for: 2+ years

### "My Experience"

September 16, 2022

5.0

So far everything has been great to work with. I had issues early on but patches were quickly made to address the issue.

Pros

The flexibility of the components and the support.

Cons

It can be very complicated to work with if you don't do it every day.

Review Source

Response from ZappySys

November 14, 2022

Thank you very much David for taking the time to review our product. We are happy to hear that our new version helped to resolve your issue.

WC

Warren C.  
Enterprise Application Architect  
Information Technology and Services  
Used the software for: 2+ years

### "SSIS Powerpack"

June 16, 2021

5.0

Pros

The powerpack is extremely well rounded and functional. It is easy to implement and our use of the extended features has increased steadily over time. The SSIS Powerpack is a key element to our successful intergration into SAP, CRM Dynamics, Office and several 3rd party vendors

Cons

Managing mappings of the JSON source can be time consuming for large sources however overall implementation of products and functionality is quick and easy.

Review Source

Response from ZappySys

June 22, 2021

Glad to hear that our product is helping you to solve important integration challenges. Regarding managing mapping on JSON Source we have feature called Import / Export Mappings. You can bulk edit Mappings in any XML editor or notepad and then load file. Contact our support if you need help with that feature.

Stephen G.  
Associate Data Analyst  
Education Management  
Used the software for: 2+ years

### "Great API Connectors For Json"

June 15, 2018

5.0

Automation

Pros

Json Source - Super easy to get data from various APIs Json Parser - Shreds complex Json into relational format

Cons

occasional bugs but support extremely responsive and helpful for troubleshooting issues and recording bugs for future releases

Review Source

KE

Kendall E.  
Data Architect  
Hospital & Health Care  
Used the software for: 2+ years

### "Best Add Ons for SSIS in the Market! "

December 6, 2021

5.0

Excellent

Pros

Ease of use, out of the box connectivity to endless data sources.

Cons

Have run into a few issues creating JSON bodies to send. Nothing to shake a stick at.

Reason for choosing ZappySys SSIS PowerPack

Ease of use, price.

Review Source

Response from ZappySys

March 16, 2022

Kendall, Thank you very much for the kind words and time you took to write this review. We are glad to hear that SSIS PowerPack enhanced your connectivity options. Feel free to contact us if you have any needs not addressed by our current toolset.

VR

Verified Reviewer  
Presentation Designer  
Executive Office  
Used the software for: Less than 6 months

### "User Friendly "

November 7, 2018

5.0

SSIS PowerPack allows us to automate all of our data and focus on analytics, not extracting data. We are able to better serve our clients when we can focus on their strategic plan and not be continually focused on collecting data from many disparate data sources.

Pros

The SSIS Powerpack is incredibly easy to use for noncoders and opens up limitless possibilities for your data. Before using the SSIS Powerpack our social media data was collected manually, which took hours and hours; this product allowed us to automate the data extracts from Facebook, Google Analytics, and YouTube. The documentation is written so that anyone slightly familiar with Visual Studio may easily follow, and the customer service is fantastic, they actually want to help you understand and use their product.

Cons

There haven't been any issues with the software that I haven't been able to review documentation and quickly fix.

Review Source

Similar Products

Featured