1 million+ businesses helped. Get advice
Get Free Advice
Home

/

Integration Software

/

ZappySys SSIS PowerPack

Software Advice offers objective insights based on verified user reviews and independent product and market research. When our advisors match you to a software provider, we may earn a referral fee.

ZappySys SSIS PowerPack 2026: Benefits, Features & Pricing

Wondering if ZappySys SSIS PowerPack is right for your organization?

Our Integration Software selection experts can help you in 15 minutes or less.

On this page
  • Overview
  • Pricing and Plans
  • Features
  • Integrations
  • User Reviews

Overview

ZappySys SSIS PowerPack
ZappySys SSIS PowerPack
4.8
(107)

Pricing

Starting at $1,499.00 per year

About ZappySys SSIS PowerPack

SSIS PowerPack is used to build complex SSIS packages with drag-and-drop functionality and coding-free custom components. It consumes data from virtually any API (REST, SOAP and OData) data source. It offers a top-notch support for phone, web meeting, email, and live chat.

It is designed to boost your productivity using easy-to-use, coding-free components to connect many cloud as well as on-premises data sources such as REST API Services, Azure Cloud, Amazon AWS Cloud, MongoDB, JSON, XML, CSV, Excel, Salesforce, PostgreSQL, Redshift, DynamoDB, Google Adwords, SOAP/Web API, Facebook, Twitter, and Zendesk. SSIS PowerPack is compatible with all versions of SQL Server 2005 or newer.

ZappySys SSIS PowerPack Screenshots

0
0
1
2
3
4

ZappySys SSIS PowerPack Pricing and Plans

Starting price: $1,499.00 per year
Free Trial
Free Version

Free

$0.00

flat rate, one time

No plan information available

    Standard

    $1,499.00

    per user, per year

    No plan information available

      Professional

      $1,899.00

      flat rate, per year

      No plan information available

        Enterprise

        $2,299.00

        flat rate, per year

        No plan information available

          Advisor Get Price CTA Image

          Confused about pricing? We've got you covered.

          Get a personalized pricing breakdown tailored to your specific needs—no guesswork, no generic estimates.

          ZappySys SSIS PowerPack Features

          • Popular features found in Integration
            API
            Configurable Workflow
            Dashboard
            Data Connectors
            Data Extraction
            Data Import/Export
            Data Management
            Multiple Data Sources
            Reporting/Analytics
            Third-Party Integrations
            Web Services
            Workflow Management
          • More features of ZappySys SSIS PowerPack
            Access Controls/Permissions
            Activity Tracking
            Alerts/Escalation
            Application Management
            Automated Scheduling
            Data Aggregation and Publishing
            Database Support
            Data Capture and Transfer
            Data Mapping
            Data Storage Management
            Data Synchronization
            Data Visualization
            Data Warehouse
            Document Management
            Drag & Drop
            ETL
            Integrations Management
            Metadata Management
            Mobile Access
            Monitoring
            Real-Time Data
            Real-Time Reporting
            Real-Time Updates
            Search/Filter
            SSL Security

          ZappySys SSIS PowerPack Integrations

          Google Analytics 360
          Google Analytics 360
          Amazon S3
          Amazon S3
          Amazon Redshift
          Amazon Redshift
          Amazon DynamoDB
          Amazon DynamoDB
          MongoDB
          MongoDB
          Mailchimp
          Mailchimp

          See all 25 integrations

          ZappySys SSIS PowerPack User Reviews

          Overall Rating

          4.8

          Ratings Breakdown

          5

          83%

          4

          15%

          3

          2%

          2

          0%

          1

          0%

          Secondary Ratings

          Ease of Use

          4.5

          Value for money

          4.7

          Customer support

          5.0

          Functionality

          4.8

          Stephen's profile

          Stephen G.

          Verified reviewer

          Education Management

          501-1000 employees

          Used daily for more than 2 years

          Review source

          Reviewed June 2018

          Great API Connectors For Json

          5

          Automation

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          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

          Read More

          RR

          Rick R.

          Verified reviewer

          Electrical/ Electronic Manufacturing

          51-200 employees

          Used daily for free trial

          Review source

          Reviewed December 2024

          Good alternative to more expensive options

          5

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

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          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.

          Reasons 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.

          Read More

          BP

          Ben P.

          Used daily for unspecified

          Review source

          Reviewed May 2018

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

          3

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

          Ratings Breakdown

          4
          Ease of use
          2
          Value for money
          3
          Customer support
          4
          Functionality
          icon
          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.

          Vendor Response

          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

          Replied June 2018

          Read More

          MS

          Manish S.

          Verified reviewer

          Banking

          201-500 employees

          Used monthly for more than 2 years

          Review source

          Reviewed February 2025

          SSIS Feature Pack - Zappysys

          5

          Excellent. It helped me solve multiple issues for my client

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          Pros:
          Versatility and options of tha package makes development very easy.
          Cons:
          Nothing. I hope the team introduces more options in the future.

          Reasons for choosing ZappySys SSIS PowerPack

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

          Read More

          DW

          David W.

          Verified reviewer

          Medical Devices

          501-1000 employees

          Used daily for less than 2 years

          Review source

          Reviewed June 2024

          Data distribution enabler.

          5

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          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.

          Reasons for choosing ZappySys SSIS PowerPack

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

          Read More

          VR

          Verified
          Reviewer

          Government Administration

          51-200 employees

          Used daily for more than 2 years

          Review source

          Reviewed November 2022

          Swiss army knife for ETL.

          4

          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.

          Ratings Breakdown

          4
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          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.

          Reasons 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.

          Vendor Response

          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 ?

          Replied December 2022

          Read More

          GR

          Gary R.

          Verified reviewer

          Government Administration

          501-1000 employees

          Used daily for more than 2 years

          Review source

          Reviewed December 2024

          Very supportive of Zappysys SSIS Power Pack

          5

          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... ;-).

          Ratings Breakdown

          4
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          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.

          Read More

          SM

          Stacy M.

          Verified reviewer

          Consumer Services

          51-200 employees

          Used daily for more than 2 years

          Review source

          Reviewed April 2025

          Essential Tools for Integration Services

          5

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          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

          Vendor Response

          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!

          Replied July 2025

          Read More

          TG

          Tom G.

          Verified reviewer

          Government Administration

          1001-5000 employees

          Used daily for more than 2 years

          Review source

          Reviewed March 2025

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

          5

          Ratings Breakdown

          4
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          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...

          Read More

          KA

          Kiran A.

          Verified reviewer

          Consumer Services

          1001-5000 employees

          Used daily for more than 2 years

          Review source

          Reviewed March 2025

          Powerful platform

          4

          Ratings Breakdown

          5
          Ease of use
          5
          Value for money
          5
          Customer support
          5
          Functionality
          icon
          Pros:
          This is a very powerful platform for API services
          Cons:
          Need more documentation as there are many ZS components.

          Read More

          Showing 1 - 10 of 107 Reviews

          Other Top Recommended Integration Software

          SAS Viya
          SAS Viya

          4.4 (12)

          Recently recommended 6 times

          Funnel
          Funnel

          4.7 (19)

          Recently recommended 5 times

          Zapier
          Zapier

          4.7 (3038)

          Recently recommended 0 times

          Domo
          Domo

          4.3 (329)

          Recently recommended 0 times

          Advisor Get Price CTA Image

          Stuck Between Options?

          Our experts can help you compare ZappySys SSIS PowerPack with other top options, so you can find the best fit for your needs.

          See what companies are saying about Software Advice