--- title: "ZappySys SSIS PowerPack Reviews 2026. Verified Reviews, Pros & Cons | Capterra" description: "Is ZappySys SSIS PowerPack the right ETL solution for you? Explore 107 verified user reviews from people in industries like yours to make a confident choice." source_url: "https://www.capterra.com/p/170286/SSIS-PowerPack/reviews/" page_type: "reviews" language: "en" publication_date: "2026-10-19" --- 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 October 19th, 2026 # Reviews of ZappySys SSIS PowerPack Ease of use 4.5 Customer Service 5.0 ## Pros and Cons in Reviews 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 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 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 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 available reviews Sort by: Most Helpful Rating Company Size Reviewer's Role Length of Use Frequency of Use Analyst Used the software for: Less than 1 year ### "SSIS power pack saves time and effort" December 4, 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! Network Administrator Used the software for: I used a free trial ### "Excellent product and tech support" December 3, 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 Scott S. M. Sr. Data Analyst Used the software for: 3-5 years ### "Great product - frequent updates - amazing support!" July 31, 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 Data Engineer Used the software for: 1-3 years ### "Highly Recommend Zappysys" September 23, 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 Used the software for: 3-5 years ### "Functionality at a cost" August 5, 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. Data Engineer Used the software for: 1-3 years ### "SSIS Powerpack features Evaluation" July 8, 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](https://www.capterra.com/p/145696/Alteryx-Designer/) Reasons 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. Senior ETL Developer Used the software for: 3-5 years ### "Excellent Tasks" May 19, 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! Intergration Advisor Used the software for: Less than 1 year ### "Good Technical support" September 26, 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! BI Used the software for: 3-5 years ### "Zappysy Overview" April 28, 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! Sr Systems Admin Used the software for: 3-5 years ### "Essential Tools for Integration Services" April 8, 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! Sr. Analyst II Used the software for: 3-5 years ### "Very supportive of Zappysys SSIS Power Pack" December 24, 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 Data Engineer Used the software for: 3-5 years ### "Zappy Feedback" November 28, 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. IT Business Analysis Used the software for: I used a free trial ### "Wonderful tools for collect data from API" November 13, 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. integration Used the software for: Less than 1 year ### "Power Pack" November 4, 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. System Analyst Used the software for: Less than 1 year ### "Great simplification of integration development process" July 4, 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. Data Engineer Used the software for: 3-5 years ### "Amazing support" January 29, 2021 5.0 The support is outstanding. Last year I was given a tight deadline and I couldn't get the Zappysys connector to do what I wanted it to do. I raised a request and within 3 days a new version was available that saved my skin. Pros What I really like about Zappysys software is that the user interface is littered with links to places where you can get more details. Cons This is going to sound odd, but, sometimes I find that the company name "Zappysys" gives people the wrong impression. It doesn't sound dull and boring enough to stop people worrying about things like longevity. I usually have to dig out our original PO to show that we've been using the software for getting on to 6 or 7 years. Review Source Response from ZappySys June 22, 2021 Thank you very much for kind words. We are happy to hear that our priority build helped you to solve your pressing need. We also like to acknowledge that we cannot improve without great feedback coming from users like you !!! Database Manager Used the software for: 1-3 years ### "Great product and support" July 16, 2019 5.0 I am not a DBA by trade. I have had to learning everything on the job. My company wanted to extend our SQL environment to include the use of SSIS packages for data transforms and other tasks. This product has helped me expand my skill set with SSIS and SQL overall. Now I still get stuck on how to do something but Zappy has a great support team that will put you in a stroller and push you around. All the while tell you everything will be ok. Great product but its the support that keeps coming back. Pros Helps simplify tasks that can be a overwhelming for the accidental DBA. With a outstanding support network to guide you through the process of using the tools. Cons some tasks are not always straight forward when it comes to working with parameters. Review Source Response from ZappySys July 16, 2019 Thank you very much for taking time to write this review. Glad to hear that you liked our product and support. Feel free to contact us again if you need help with our product in future. BI Team Lead Used the software for: 3-5 years ### "Stellar Support Every. Single. Time." August 21, 2019 5.0 We're breaking down application data silos to deliver more robust BI to the business. SSIS PowerPack & the team supporting it is integral to our success in these efforts. Pros The people backing it! Also I love being able to Test/Dev components for free to make sure they actually help us solve our business problems, and then make a purchase only when we're ready to go to production Cons The error messages - for a software that is trying to smooth over the technical complexity of joining disparate data sources, it does not help to provide the raw error messages with no suggestions. Review Source Developer Used the software for: 1-3 years ### "Excellent Product" October 10, 2023 5.0 Workflow Bulk Api Calls Pros A host of third party connectors which are well documented Cons Would like to have command line tooling integrated to the power pack Reasons for choosing ZappySys SSIS PowerPack Not Applicable Review Source Analyst Used the software for: Less than 1 year ### "Brilliant product and great customer support. " July 3, 2019 5.0 Pros Easy to use. Originally purchased to use the SF component only but quickly found a use for most others component too. Customer support is excellent. Cons Can't fault it!!!!!!!!!!!!!!!!!!!!!!!!!! Review Source Response from ZappySys July 3, 2019 Thank you very much for taking time to write review. Also, happy to hear that our products and customer support is meeting your expectations. BI Developer/Database Administrator Used the software for: Less than 1 year ### "Excellent Solution " September 16, 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 IT Manager Used the software for: 3-5 years ### "Powerful Tool" October 14, 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. Sr BI Analyst Used the software for: 3-5 years ### "Excellent product and excellent customer service." March 1, 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 IT Developer Used the software for: Less than 1 year ### "Works great with CRM. Experienced support team " May 19, 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. SQL Developer Used the software for: Less than 1 year ### "Very responsive and helpful" November 2, 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 ## Send me user reviews about this product ### Fill out the form and we'll send a list of the top-rated software based on real user reviews directly to your inbox.