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

> 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

# Reviews of ZappySys SSIS PowerPack

Ease of use

4.5

Customer Service

5.0

## Pros and Cons in Reviews

MA

Mogtaba A

Data EngineerStaffing and Recruiting, 501 - 1,000 employeesUsed the software for: 1-2 years.

“Json Parsing, arrays Flatten options, Pagination, Authentication methods and array filter, all of these features make our life easy“

July 7, 2025

MA

Mogtaba A

Data EngineerStaffing and Recruiting, 501 - 1,000 employeesUsed the software for: 1-2 years.

“SSIS powerpack doesn't shows the exact Column Name the caused the error if a package Failed to run, hope to do some enhancements on this“

July 7, 2025

MS

Mary S

AnalystGovernment Administration, 51 - 200 employeesUsed the software for: Less than 6 months.

“It allows me to import/export JSON and XML to/from SQL Server with much more ease than using built-in available SSIS available tools. “

November 22, 2025

BG

Bhanu G

Senior ETL DeveloperRetail, 501 - 1,000 employeesUsed the software for: More than 2 years.

“None at the moment to point out but I am seeing less technical help during IST nights.“

May 16, 2025

PZ

Patricia Z

Data EngineerConsumer Services, 1,001 - 5,000 employeesUsed the software for: 1-2 years.

“It so far has all the features (data flow tasks and connectors) that I need right now to reach cloud data repos, etc. and Zappysys is continually updating the product. “

September 19, 2025

by

begüm y

BIInformation Technology and Services, 5,001 - 10,000 employeesUsed the software for: More than 2 years.

“tasks are sometimes too complicated to set up.“

April 23, 2025

by

begüm y

BIInformation Technology and Services, 5,001 - 10,000 employeesUsed the software for: More than 2 years.

“tasks have a lot of option and we can create so many projects with using them.“

April 23, 2025

JC

Jaycee C

BI MgrConsumer Goods, 51 - 200 employeesUsed the software for: More than 2 years.

“The online documentation is sometimes incomplete.“

March 20, 2023

## Showing most helpful reviews

Showing 1-25 of 107 Reviews

Sort by:

Most Helpful

Rating

Company Size

Reviewer's Role

Length of Use

Frequency of Use

Scott S. M.  
Sr. Data Analyst  
Education Management  
Used the software for: 2+ years

### "Great product - frequent updates - amazing support!"

July 30, 2018

5.0

This software helps me quickly ingest data sources that are obscure, out of the ordinary, or that require special accommodation. Saves me from having to write Python and the interaction it provides me with REST APIs is extremely powerful.

Pros

I feel like you can do anything with data movement when it comes to using the ZappySys SSIS Power Pack. It even does a lot of the native SSIS stuff better. The product gets regular updates and releases and the support team is amazing at helping you out. They go above and beyond to work with you on issues that come up.

Cons

Nothing I can think of. Even when I have found a bug, the ZappySys team works to release a fix in less than a week. Very good to know that they listen to their customers.

Review Source

PZ

Patricia Z.  
Data Engineer  
Consumer Services  
Used the software for: 1-2 years

### "Highly Recommend Zappysys"

September 19, 2025

5.0

Pretty much summed up the first 2 questions. It is so flexible almost against it's own good--but don't tell them I said that because I don't want to lose the flexibility, just want to understand more :) Zappysys has fantastic support as well. Sometimes it seems the email back and forth is delaying but it's getting to the root to determine if a call or just a screenshot is needed.

Pros

It so far has all the features (data flow tasks and connectors) that I need right now to reach cloud data repos, etc. and Zappysys is continually updating the product. With our license we benefit from these added features.

Cons

Sometimes the widget interfaces aren't communicating very clearly the information needed for the configuration. While Zappysys did an amazing job (most vendors never include this in their product) including examples, links and even help text, some of these screens contain over 100 pieces of information and sometimes it's hard to know which 1 or 2 or 7 things need to be filled in and when and why.

Switched from

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

Price and overall product value Price and overall product value

Review Source

Response from ZappySys

September 26, 2025

Hi Petricia, thank you for your detailed feedback! We’re happy to hear that the flexibility and wide range of connectors are helping you reach your cloud data sources. We appreciate your point about the interface being dense at times - our team is working to make setup screens more intuitive while keeping the flexibility you value. Great to know you find our support helpful, even if email takes a few rounds to reach the best solution. Your insights mean a lot and help us keep improving. Thanks again for choosing ZappySys!

Cody B.  
Sr Data Engineer  
Financial Services  
Used the software for: 2+ years

### "Functionality at a cost"

July 30, 2020

3.0

Pros

SSIS PowerPach has tons of features and connectors

Cons

Price was ultimately my least favorite part of SSIS PowerPack

Alternatives considered

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

Review Source

Response from ZappySys

October 14, 2020

Thank you very much for taking time to write this review. We understand you have price concern. Please contact our sales team and someone will be happy to address your concern.

MA

Mogtaba A.  
Data Engineer  
Staffing and Recruiting  
Used the software for: 1-2 years

### "SSIS Powerpack features Evaluation"

July 7, 2025

5.0

It's the most suitable tool designed for API and Data integration solution that I used in the last 7 years

Pros

Json Parsing, arrays Flatten options, Pagination, Authentication methods and array filter, all of these features make our life easy

Cons

SSIS powerpack doesn't shows the exact Column Name the caused the error if a package Failed to run, hope to do some enhancements on this

Alternatives considered

[Alteryx Designer](https://www.capterra.com/p/145696/Alteryx-Designer/)

Reason for choosing ZappySys SSIS PowerPack

it's mainly Designed for API and data integration

Review Source

Response from ZappySys

July 19, 2025

Thank you very much for taking the time to write this review. We are pleased that our JSON Parser/API-related features have helped you. Regarding your feedback on the column name errors, we are aware of the issue and will do our best to improve it in the future. Sometimes we are constrained by the source API system. Please email our support with an example error message so we can investigate further.

mA

marc A.  
Network Administrator  
Financial Services  
Used the software for: I used a free trial

### "Excellent product and tech support"

August 29, 2025

5.0

I worked with support engineer \[sensitive content hidden\] for the trial that we did. He was phenomenal in getting our automation setup. We are definitely going to buy the product.

Pros

The setup and deployment was great. It seems to work seamless with Visual studio. The tools seem very easy to use as well.

Cons

We just downloaded the product to start with the trial. So far we have not found anything that we do not like.

Switched from

[SolarWinds Task Factory](https://www.capterra.com/p/178934/Task-Factory/)

Solarwinds could not get their O365 connector to work with Oauth 2

Review Source

BG

Bhanu G.  
Senior ETL Developer  
Retail  
Used the software for: 2+ years

### "Excellent Tasks"

May 16, 2025

5.0

Excellent. Support wise also it is providing quick solutions to issues. Really awesome tasks it has. Thank you.

Pros

It has very good number of features and liked it very much. Every zappysys task is needed.

Cons

None at the moment to point out but I am seeing less technical help during IST nights. That could be improved.

Review Source

Response from ZappySys

July 19, 2025

Thank you, Bhanu, for the great review and your continued trust in SSIS PowerPack! We're glad the features have been valuable to your work. Regarding IST support — we do offer coverage during IST hours, so if there was a specific time slot where you had trouble reaching us, please let us know and we’ll investigate. Your feedback helps us improve!

bY

begüm Y.  
BI  
Information Technology and Services  
Used the software for: 2+ years

### "Zappysy Overview"

April 23, 2025

5.0

Pros

tasks have a lot of option and we can create so many projects with using them. mostly API connections.

Cons

tasks are sometimes too complicated to set up. Documentation is not enough for some cases. It can be more user friendly interface.

Review Source

Response from ZappySys

July 19, 2025

Thank you, Begüm, for your honest feedback and for using SSIS PowerPack for over two years. We're glad the flexibility of our tasks has helped with your API projects. We appreciate your input on setup complexity and documentation — we're actively working to improve both clarity and user experience. Your feedback is valuable and helps guide our improvements!

MS

Mary S.  
Analyst  
Government Administration  
Used the software for: Less than 6 months

### "SSIS power pack saves time and effort"

November 22, 2025

5.0

The support service is excellent and very fast. If I have a question about using their tools, like which tool within the SSIS power pack, is the best tool to use to solve a particular problem, they will help and make suggestions.

Pros

It allows me to import/export JSON and XML to/from SQL Server with much more ease than using built-in available SSIS available tools. It picks up where the built and tools leave off… it requires some technical knowledge, but you don’t have to learn to write complex programs, like in Java. This saves a lot of time and effort, especially in small IT departments like ours!

Cons

Occasionally, while using their tools in SSIS, there are little pop-up or comment boxes that get displayed and should, but don’t, disappear again.

Review Source

Response from ZappySys

January 6, 2026

Hi Mary, Thank you for your wonderful feedback! We’re glad ZappySys tools have made JSON/XML integration with SQL Server easier for your team and saved time. We appreciate your kind words about our support—it’s always our goal to provide quick and helpful assistance. Thanks for sharing your experience and for choosing ZappySys!

VRP

Vijay Raj P.  
Intergration Advisor  
Electrical/Electronic Manufacturing  
Used the software for: 6-12 months

### "Good Technical support"

September 25, 2025

4.0

Pros

Value for Money, Setup and Deployment. Support team availability and spontaneous response. Easy to communicate

Cons

Automatic checks not available on patch upgrade or alerts on upgrades, system should check if any new features are introduced in the latest release. Inform customers to see if it benefits them.

Review Source

Response from ZappySys

October 28, 2025

Thanks so much, Vijay, for sharing your feedback! We’re glad you found our product easy to use and our support team responsive. About the version alerts — these usually work unless network settings block our update checks. We’re also adding email notifications soon to ensure you never miss an update. Appreciate your feedback and support!

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

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

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.

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.

KW

Ken W.  
Director of Implementation  
Utilities  
Used the software for: 2+ years

### "Save development time with this add-on"

June 18, 2021

4.0

Every organization I went to, I have recommended purchasing this add-on because the steps it performs avoids a lot of programming and setup. I've consistently delivered and no one can put a dollar amount on the development time saved. It can theoretically pay for itself in a week for a senior resource to work on packages.

Pros

We use the JSON file and API connectivity the most. Everything is configuration where there is no coding at all.

Cons

Some rough parts in the Excel component that can be further enhanced so it behaves like the CSV component in terms of looping through files. Need one for Access files as well.

Reason for choosing ZappySys SSIS PowerPack

This package covers most of what we need, but we still need specialized coverage from other add-ons, which is unavoidable to be purchasing others where needed after evaluation.

Review Source

Response from ZappySys

June 22, 2021

Thank you very much for recommending ZappySys. We are glad to hear that how our products helped to achieve great ROI on many projects. Regarding your comment on Excel Component improvements / Looping - Can you please send us some clues - Just mention in your Support Ticket so we have correct information logged. We do have option to specify Wildcard (\*.xlsx) on Excel connection incase you didnt try it? Let us know your need so we can help you.

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.

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

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.

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

PA

Patrick A.  
Data Services Lead  
Environmental Services  
Used the software for: 2+ years

### "Powerful and Convinient Product"

May 20, 2022

5.0

Helped us to integrate internal data with external vendors seemlessly.

Pros

REST API Software - Very useful in aiding with integrations.

Cons

The general GUIs could be improved upon.

Review Source

DC

Donald C.  
Director of Business Systems  
Wine and Spirits  
Used the software for: 1-2 years

### "Zappy Saves the Day"

September 30, 2020

5.0

We use the tool to connect with multiple systems and webservices. When we have been stuck the gracious staff of zappysys has done remote sessions and got us moving in the right direction.

Pros

The ease of use of the software. The documentation and support is excellent.

Cons

I would like to see the merge action be added to the dynamics 365 destination connector.

Reason for choosing ZappySys SSIS PowerPack

Documentation and Support and the number of connectors.

Review Source

Response from ZappySys

October 14, 2020

Thank you so much for your review and kind words about our Support Staff. We will definitely review your feature request. You can always contact us via Live Chat / Ticket System if you want to discuss your specific need.

DP

Dwaine P.  
BI Developer/Database Administrator  
Construction  
Used the software for: Less than 6 months

### "Excellent Solution "

June 14, 2022

5.0

We solved our issue of easily connecting to web rest APIs. The overall experience with this product is nothing short of fantastic.

Pros

The ease of connecting to Web Rest APIs is the reason we purchased the product. We are using it to connect to many different APIs. The support is phenomenal!! Their support team helped me find bugs in my vendor’s API.

Cons

I have not found anything not to like. The product is excellent.

Review Source

BJ

Barbara J.  
IT Manager  
Transportation/Trucking/Railroad  
Used the software for: 2+ years

### "Powerful Tool"

October 1, 2020

5.0

Pros

This software saved countless hours of development and the expense of a developer to post and consume JSON data. Its amazing. The support staff are phenomenal!

Cons

nothing. easy to configure and get into production

Review Source

Response from ZappySys

October 14, 2020

Thank you very much for taking time to write this review. We are happy to hear about time / cost saved using our product.

GV

Greg V.  
Sr BI Analyst  
Wireless  
Used the software for: 2+ years

### "Excellent product and excellent customer service."

February 28, 2018

5.0

Save time & money by not having to script common tasks.

Pros

Easy to use. Comprehensive set of tasks/components. But, above all, their customer service is exceptional. They go above and beyond to make sure you're happy and their products are doing what you need them to do.

Cons

I have yet to find a single shortcoming in any of the tasks/components included in the purchase. It has exceeded our expectations.

Review Source

VC

Vikas C.  
IT Developer  
Information Technology and Services  
Used the software for: Less than 6 months

### "Works great with CRM. Experienced support team "

May 15, 2020

4.0

Pros

Integration to CRM via SSIS is very easy to setup and understand. Integration does not add any delays to CRM actions. Support team is quick and very knowledgeable. They resolve issues quickly and send updates about issues on a regular basis.

Cons

Error messages are sometimes hard to understand and resolve. Only 75-80% chances for you to find answers on ZappySys support site.

Review Source

Response from ZappySys

May 19, 2020

Thank you very much for taking time to write this review. We are glad that your CRM integration is working well. Regarding your concern on friendly error messages - we totally understand how you feel when error message is hard to understand. With each iteration we strive to improve them and make sure its user friendly however many times we have no control on underlying systems (e.g. CRM / API source) and it becomes really hard to show their error messages in meaningful way to SSIS Users. We are fully committed to improve upon your feedback.

VR

Verified Reviewer  
SQL Developer  
Real Estate  
Used the software for: Less than 6 months

### "Very responsive and helpful"

October 30, 2018

5.0

I'm trying to consume an API from a vendor that we do business with. I was able to use the JSON source without issues and now I'm trying another API with OAuth 2.0, that is proving to be a little complicated. I've contacted support and the guys are very responsive and helpful always!

Pros

The SSIS components work well and are reliable.

Cons

the REST components can get a little tricky but that's because REST especially with OAuth 2.0 is complicated as it is.

Review Source

Similar Products

Featured

## Related categories

[Integration](https://www.capterra.com/integration-software/)