About SSIS PowerPack
SSIS PowerPack is a collection of 70+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). SSIS PowerPack 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, Redshift, DynamoDB, Google API (i.e. Analytics, AdWords), SOAP/Web API, Facebook, Twitter, Zendesk, eBay and many more.
SSIS PowerPack also includes high quality FREE commercial components and tasks with full support/upgrade…. Download 30 days FREE Trial from below link
We are so glad that we chose ZappySys …We have been using ZappySys for our data warehouse SSIS ETL for a couple of years and we LOVE the product so much. It comes with so many features and functions. Whenever we run into obstacle, ZappySys has a solution for us. Support response is fast and get the right answer all the time. At the very beginning when we were evaluating third party SSIS controls, we also tried CData software which was fast and easy to connect to data sources and destinations. However, features and functions were very limited partly due to data schema was pre-programmed by CData. Since every business is different, we needed something flexible and granularity. We are so glad that we chose ZappySys PowerPack Awesome framework to bring a small company into the world of connectivity!Zappysys has been a fantastic way to bring our small company into the world of apis, automation, and systems integration by providing tools within an easy-to-use framework. As a small company we do not have the resources to hire a full time developer. For our company, Zappysys has provided the essential framework needed for us to take everything to the next level by getting us past many of the nuts and bolts hurdles to initial stages of development. Additionally, every time we have worked with their support team they have provided a one-on-one consulting session to solve our problem. And what’s more is they always answer the call quickly so we are never left hanging out to dry.  Ben Kingery Oxspring Paul Very resourceful and helpfulWe have been working with the support team at ZappySys for over a year now and have consistently found them to be extremely helpful in resolving any issues we have encountered. They have proven themselves to be resourceful and creative in offering multiple solutions to overcome any and all challenges we have faced in our day-to day-operations. Either online or by telephone, their personnel are reliable, energetic and sensitive to the urgency of our problem-solving needs. A well-organized team of real go-getters. Great Product & Great SupportThe responsiveness of your support staff during the evaluation period really has been excellent. I’ve contacted them a few times with queries specific to the scenario I am working with and they have answered straight away via chat and provide exactly the detailed technical input required to progress. Please convey my sincere gratitude to your support team, they have been a great help. The functionality of the component that is of particular interest (the REST source) is very powerful, and due to constraints regarding access to the environment that I am targeting, it is in fact is the only thing I have found that I am able to use and I have tried a few other components from major vendors also. When it comes to integrating data flow between multiple technologies, the ZappySys software and their amazing support are well worth the investment.At Synchronous Customers, we need a way to connect various types of data together quickly. The super handy Zappysys Connectors and great documentation allow us to do this will having to write a lot of the code. The system is stable and reliable and the support team really comes through for us if we get stuck on something. 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. Thank you ZappySys! We are glad we found you and highly recommend! 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.I looked everywhere for a product that could easily integrate to a specific web portal backend api via JSON, and after many attempts the ZappySys product was the only solution that could give me all the options I needed in a quick & clean interface within SSIS. Coupled with some great tech support and customer support, I would definitely recommend ZappySys SSIS PowerPack. Great SupportI couldn’t be happier with the support I received this evening. I had been building out a proof of concept and just couldn’t get past one last error. I submitted a support request and had someone logged in and fixing things within 2 hours. Not only did they solve my problem but went on to assist with answers to basic SSIS tasks.  Barry Wilson |
OverviewWhat's new (Version History )System requirementsFree License for MVP / Blogger / Influencer
Why SSIS PowerPack?
- Coding free, drag and drop high performance suite of Custom SSIS Components and SSIS Tasks
- Used by many companies around the globe
- Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
- Support for 32bit and 64bit Server/Desktop OS
- Easy to use, Familiar looks and feel and fully integrated in BIDS/SSDT
- No license needed if you are developing/testing in BIDS/SSDT
- Rapid update cycle and prompt support (See what's new). We will help you over phone, web meetings and via email.
- 30 days money back guarantee if not satisfied for whatever reason.
Data Integration Categories
- File Formats
- Microsoft Azure Cloud
- Amazon AWS Cloud
- SOAP / REST API
- Secure FTP
- Big Data / NoSQL (MongoDB, DynamoDB, Redshift...)
- 3rd Party Online Services
- Email and Reporting
- Salesforce
- Microsoft Dynamics CRM
- Everyday things (Tasks to speedup common scenarios)
| Excel Integration | ||
|---|---|---|
 Excel Source |
 Excel Destination |
 Export Excel File Task |
| Secure FTP Integration | ||
|---|---|---|
 SFTP Task (FTP,FTPS,Secure FTP) |
 Secure FTP Source for JSON File |
 Secure FTP Source for XML File |
 Secure FTP Source for CSV File |
 Secure FTP Destination for CSV File |
|
| Salesforce Connectivity | ||
|---|---|---|
 Salesforce Source Connector |
 Salesforce Destination Connector |
 Salesforce API Task (Call REST/SOAP API) |
| Microsoft Dynamics CRM (CRM Online 365 / On-Premises) | ||
|---|---|---|
 Dynamics CRM Source Connector |
 Dynamics CRM Destination Connector |
|
| Email / Reporting | ||
|---|---|---|
 Send HTML Email Task |
 Report Generator Task |
|
SSIS Tasks
| Name | Description Features | FREE Edition | Standard Edition | Professional Edition | |
|---|---|---|---|---|---|
|
SFTP Task (FTP,FTPS,Secure FTP)v2.2+ [See] |
|
 |
 |
|
 |
SSIS Compression Task (Zip/Unzip)FREE v2.2+ [See] |
|
|
|
|
 |
Export XML File Taskv2.2+ [See] |
|
|
|
|
 |
XML Parser Task (FREE)v2.2+ [See] |
|
|
|
|
 |
Regex Parser Task (FREE)v2.2+ [See] |
|
|
|
|
 |
Advanced File System Taskv1.9+ [See] |
|
|
|
|
 **NEW** |
Validation Taskv1.9+ [See] |
|
|
|
|
 |
Download File Task (FREE)v1.9+ [See] |
|
|
|
|
 |
Amazon Redshift Cluster Management Taskv1.7.3+ [See] |
|
|
|
|
 |
REST API Web Service Taskv1.7+ [See] |
|
|
|
|
 |
Logging Task (FREE)v1.7+ [See] |
|
|
|
|
|
Send HTML Email Task (FREE)v1.6+ [See] |
|
|
|
|
|
Export Excel File Taskv1.6+ [See] |
|
|
|
|
 |
Export JSON File Taskv1.6+ [See] |
|
|
|
|
 |
Export CSV File taskv1.6+ [See] |
|
|
|
|
 |
Amazon S3 Cloud Storage Task |
|
|
|
|
 |
Microsoft Azure Cloud Storage Task |
|
|
|
|
 |
Amazon Redshift Data Transfer Task |
|
|
|
|
 |
Amazon Redshift ExecuteSQL Task |
|
|
|
|
 |
Amazon DynamoDB ExecuteSQL Task |
|
|
|
|
 |
MongoDB ExecuteSQL Task |
|
|
|
|
|
Reporting Services (SSRS) Task |
|
|
|
|
 |
Timer Task (FREE) |
|
|
|
|
 |
JSON Parser Task (FREE) |
|
|
|
|
|
Salesforce API Task (Call REST/SOAP API) |
|
|
|
|
 **NEW** |
PostgreSQL Execute SQL Task (Execute SQL sentences) |
|
|
|
|
SSIS Components for Source
| Name | Description Features | FREE Edition | Standard Edition | Professional Edition | |
|---|---|---|---|---|---|
 |
Google Analytics Source |
|
|
|
|
 |
HTML Table Sourcev1.6+ [See] |
|
|
|
|
 |
JSON Source (REST API Source) |
|
|
|
|
 |
XML Source (File / SOAP / REST Web Service)v1.9+ [See] |
|
|
|
|
 |
MongoDB Source |
|
|
|
|
 |
Azure Table Storage Source |
|
|
|
|
 |
Amazon DynamoDB Source |
|
|
|
|
 |
DummyData Source (FREE) |
|
|
|
|
|
Salesforce Source |
|
|
|
|
|
Dynamics CRM Source |
|
|
|
|
 |
Amazon Redshift Source |
|
|
|
|
 |
CSV Source (File / Web API) |
|
|
|
|
|
Excel Source |
|
|
|
|
 |
Azure Blob Source for CSV File |
|
|
|
|
 |
Azure Blob Source for XML File |
|
|
|
|
 |
Azure Blob Source for JSON File |
|
|
|
|
 |
Amazon S3 Source for CSV File |
|
|
|
|
 |
Amazon S3 Source for XML File |
|
|
|
|
 |
Amazon S3 Source for JSON File |
|
|
|
|
|
Secure FTP Source for CSV File |
|
|
|
|
|
Secure FTP Source for XML File |
|
|
|
|
 **NEW** |
PostgreSQL Source |
|
|
|
|
SSIS Components for Target
| Name | Description Features | FREE Edition | Standard Edition | Professional Edition | |
|---|---|---|---|---|---|
 |
Trash Destination |
|
|
|
|
 |
MongoDB Destination |
|
|
|
|
 |
Azure Table Storage Destination |
|
|
|
|
 |
Amazon AWS DynamoDB Destination |
|
|
|
|
 **NEW** |
Amazon Redshift Destination |
|
|
|
|
 |
Web API Destination |
|
|
|
|
|
Salesforce Destination |
|
|
|
|
|
Dynamics CRM Destination |
|
|
|
|
|
Excel Destination |
|
|
|
|
 |
CSV Destination |
|
|
|
|
 |
Azure Blob Destination for CSV File |
|
|
|
|
 |
Amazon S3 Destination for CSV File |
|
|
|
|
|
Secure FTP Destination for CSV File |
|
|
|
|
 **NEW** |
PostgreSQL destination |
|
|
|
|
 **NEW** |
Upsert destination |
|
|
|
|
SSIS Transforms
| Name | Description Features | FREE Edition | Standard Edition | Professional Edition | |
|---|---|---|---|---|---|
 |
Set Variable Transform FREE |
|
|
|
|
 **NEW** |
JSON Parser Transformv2.2+ [See] |
|
|
|
|
 **NEW** |
XML Parser Transformv2.2+ [See] |
|
|
|
|
 **NEW** |
XML Generator Transformv2.2+ [See] |
|
|
|
|
 **NEW** |
JSON Generator Transformv1.8+ [See] |
|
|
|
|
 |
CSV Parser Transform |
|
|
|
|
 **NEW** |
CSV Generator Transform |
|
|
|
|
- .Net framework 3.5
- SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014/2016 or 2017
- To design SSIS 2012 packages : SSDT-BI (SQL Server Data Tools) for Visual Studio 2012 or 2010 or 2015 must be installed.
- To design SSIS 2014 packages : SSDT-BI (SQL Server Data Tools) for Visual Studio 2013 or 2015 must be installed.
- To design SSIS 2016 packages : SSDT-BI (SQL Server Data Tools) for Visual Studio 2015 must be installed.
- To design SSIS 2005, 2008, 2008 R2 packages : BIDS (Business Intelligence Development Studio) for Visual Studio 2008 must be installed.
- Supported Client Operating Systems: We support any OS where you can install SSIS Client tools (e.g. Visual Studio). We have tested product with Windows 7, Windows 8, Windows 8.1, Windows 10
- Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
If you are a Microsoft BI Professional and you meet any of the following criterias, then you may be eligible to obtain FREE license(s) of ZappySys Products (Worth upto 3000 US$). Along with FREE license you also get premium support and option to interact with DEV team members to share your ideas and feedback. We also provide FREE web meeting sessions for integration need if you qualify.
Who is eligible for FREE License?
- MVP FREE License - If you are an MVP (Most Valued Professional) and plan to write / present about ZappySys products, you may qualify for FREE License.
- Blogger FREE License - If have already written a review / article about ZappySys product then send us a proof URL to request your FREE License.
- Public Speaker / Influencer FREE License - If you talk about Microsoft BI / Tools and plan to present or talk about ZappySys Products.
Click Here to Claim your FREE License. Please mention in few lines how you plan to influence ZappySys Products. Also provide proof (i.e. your blog URL or MVP Status proof) and we will be happy to email you License Key with full Support/Upgrades.
Keep Support Active: If you wish to keep your ongoing support active for FREE license then you must share at least one proof each year which includes public mention about ZappySys Product (i.e. in Blog, Social Media, event).
Submit requirements to renew: You can renew your support/upgrades of FREE license by submitting requirements here