FAQs (Frequently Asked Questions)

SSIS PowerPack is licensed by machine. However if you test/debug SSIS packages inside Visual Studio SSIS designer then license is not needed. If you run package from command line/SQL Agent job then you will need license on that machine.

For example: If you have 7 developers in your team and 3 ETL servers (DEV, QA, PROD) which runs SSIS Packages via SQL Agent Job then most likely you will need 3 licenses for those servers (Assuming server is not cluster)

For Full Explanation check below links:

• SSIS PowerPack Licensing Terms
• ODBC PowerPack Licensing Terms

ODBC PowerPack is licensed by machine. You can buy a Desktop or Server License based on Your OS Type.  You need a license for each machine where you planning to install ZappySys Driver.

What is considered as Desktop?

Any machine where only a single user is active (Directly or via Remote desktop) is typically considered as Desktop OS. For example, Windows 11, Windows 10, Windows 7 are considered as a Desktop OS. For such a use case, you can buy the desktop license at a cheaper price.

What is considered as Server?

Any machine which is accessed by multiple users is typically considered as server. For example, Microsoft Windows Server 2022, 2019, 2016, 2012 is considered a Server OS. You will need the server license for such a case.

No – SSIS PowerPack is not supported on Amazon Relational Database Service because RDS doesn’t allow 3rd party installers as Microsoft ADF allows. But we do support ADF (Azure Data Factory). Please follow this article for details.

Yes – SSIS PowerPack is supported on Azure Data Factory (SSIS Runtime), check this article for details.

Any license you purchase from ZappySys would work fine on Azure Data Factory (SSIS – IR) nodes. We license by cluster so no need to buy a separate license for each node. You will need one license per cluster. You can scale your ADF cluster from one node to 10 nodes and you can still use the same license key on all SSIS-IR nodes. If you create a new cluster with a different name then you will have to purchase an extra license, assuming you wish to use ZappySys Products on that new cluster.  Prices listed here are same for On-Premises version vs ADF SSIS-IR (No difference in price)

Hope this helps!! If you still have questions or need quote then Contact Sales.  If you don’t need quote then purchase online by clicking the Buy link on this page (next to the product you wish to purchase).

When you install SSIS PowerPack on any machine it starts as Trial Software. When you designing packages in Visual Studio it will show you as Trial Software (Unless you activated Paid License Key). Once Trial Expires, SSIS PowerPack becomes Visual Studio Only version. Which means you can Design / Test / Debug SSIS Packages inside Visual Studio without Paid license. After Trial expires you wont be able to execute packages out side visual studio designer (e.g. Command Line, SQL Agent Job, C# Programs). We have documented this in detail here.

Yes – Each server where you run packages outside Visual Studio will require a license. In the real world, most of the customers will develop/test packages on workstations inside Visual Studio first and then deploy to DEV/QA/PROD servers and run via SQL Agent / some other way (e.g. Command line, PowerShell, C#).

Yes – each node in a cluster requires its own license because technically node is a separate machine. However, if you are running Active-Passive configuration then you can switch the license to different node manually when needed. This approach may not be preferred by some customers due to the hassle of switching license manually. If you are OK with this approach then you can buy a license for active nodes only.

We offer two license models (Perpetual and Subscription). Subscription is common choice for the fact that you don’t have to worry buying support after first year and its hassle free. Perpetual license is one time purchase, license key never expires, First year support and upgrades included. A subscription license is time bound. As long as you keep renewing your subscription each year you will get new license key (In most cases you won’t have to apply new key each year because it will be automatic behind the scene as long as you are connected to the internet). See below description for each license type.

Perpetual License

Perpetual license is one time purchase and the license key never expires. If you buy the perpetual license then first-year support and upgrades will be included with your purchase. After the first year if you wish to continue getting support and Bug Fixes/New features, then you can purchase additional years of the support plan (optional). Click here to see Perpetual Price table.

Annual Subscription License

Annual subscription is a pay as you go type of plan. Its usually much cheaper than the perpetual license. Support and upgrades are included in the subscription license plan. Click here to see Subscription Price table.

If you are still not sure which license type to choose, please review comparison table below:
Perpetual vs Subscription License

Check this post for more information.

Check this post for more information.

In most cases we give trial extension (No more than 60 days including original trial). If you need more time to test our software and your trial is about to expire or already expired then perform the following steps.

1. Launch License manager using any of the following ways
   Goto Start Menu > ZappySys > SSIS PowerPack > Click “License Manager”
   — OR —
   Double click ZappySys Task or Component Icon in SSIS designer and at the top click on Link which shows License Type (e.g. FREE, Standard Edition, Pro Edition etc)
2. On the license manager UI click Trial Extension button. It will open email > Fill out the requested information and send email to us. Once we review your request we will send you extension.

When you install product, we typically copy EULA file in the program directory so you can review there. If you need to download file in PDF format then check below link. We have single EULA for all products. Click on the below link to download EULA in desired File format (e.g. html, pdf, word (i.e. *.rtf) ).

PDF format (ZappySys PowerPack End User License Agreement – EULA)

HTML format (ZappySys PowerPack End User License Agreement – EULA)

Word format (ZappySys PowerPack End User License Agreement – EULA)

Our PowerPack is licensed by machine, and if you want to reuse the license, then we recommend that you deactivate the license before decommissioning/renaming/releasing the machine or server. If you do not deactivate the license, you will not be able to reuse the same license on any new machine or server.

SSIS Powerpack is licensed by machine or node, And each worker Node machine needs its own SSIS Powerpack installation and license key (Assuming they all run on different machines). A master node usually is just a controller and no SSIS Powerpack installation is needed on that node so you do not need a license there but if you plan to use Master Node as a Worker node too, you need to buy a license for that as well. To be the safe side you can buy licenses for all nodes participating in Scale-Out Process Master + Workers. In short, if SSIS Powerpack is needed to be installed on the Machine participating in Scale-Out, needs its own license.

Example-1 (Two SSIS Powerpack licenses for worker nodes) + Optional 1 license for master node:
MasterNode-Server001
WorkerNode1-Server002 (Needs license)
WorkerNode2-Server003 (Needs license)

Example-2 (Two SSIS Powerpack licenses for worker nodes):
MasterNode-Server001
WorkerNode1-Server001 (Needs license)
WorkerNode2-Server002 (Needs license)

Example-3 (One SSIS Powerpack license for worker node):
MasterNode-Server001
WorkerNode1-Server001 (Needs license)

By default subscription is on auto-renew mode after your first purchase. When its time to renew subscription we send notification 10 days before the renewal date. If you do not want to renew then you will have the option to cancel your subscription. You can visit your Subscription account page anytime and click Cancel Subscription.

If you don’t renew your Subscription or Cancel your Subscription then product will stop working (any FREE components will still work).

It Depends – if your server has internet connectivity then most likely you wont have to activate new key manually. When we detect expired license for the subscription we will contact the ZappySys license server to obtain new license key for you. In some cases when internet is blocked on server or you have proxy issue then you many have to activate license key manually or activate in offline mode.

No – subscription license comes with support and upgrades plan so you don’t have to worry buying that separately. As long as your subscription is active you are eligible for technical support and obtaining latest version for new features/bug fixes.

No – you cannot buy subscription using check / wire method. Only method we allow is Credit/Debit or Paypal for Subscription.

No – Our system automatically charges each year (last payment method on file). You may cancel the subscription anytime to stop auto renew.

Cancelling your subscription is just 2-click process. Goto your Account URL (Mailed at the time of purchase) and click Cancel the subscription option.

Perpetual license key does not expire unlike Subscription license key so you don’t have to worry on that part. However we strongly recommend you to renew your support plan each year so you can contact technical support, upgrade to new version to get new features / critical bug fixes.

No – We include first year of support and upgrades along with your perpetual license purchase. After first year, you may renew your support agreement. It’s optional however, we strongly recommend you to renew your support plan each year so you can contact technical support, upgrade to new version to get new features / critical bug fixes.

You can buy online from our secure store or request official quote if that’s needed by your accounting department. Click here to learn more about purchase process and payment options. To request official quote for purchase Click here. On the page enter your information and submit the form. Mention following details in your message to receive accurate quote.

Product + Quantity
Company Name:
First Name:
Last Name:
Email:
Phone:
Address:

For some customers accounting department may ask for quote before they can purchase. To request official quote for purchase Click here. On the page enter your information and submit the form. Mention following details in your message to receive accurate quote.

Product + Quantity
Company Name:
First Name:
Last Name:
Email:
Phone:
Address:

We support all major Creditcards / Debitcards, Wire Transfer, Paypal. And if you are in USA then we also support Check/Money order. Click here to learn more about purchase options.

No – Tax is added separately during checkout. Each country/State may have different rules for tax and our checkout process will calculate it based on Billing address / VAT number.

Yes – You can pay in your local currency. By default, we may detect your country and show the price in local currency during checkout process but you can manually change country any time from the dropdown (found at the top of checkout page).

Yes – Select wire transfer method on payment options page. Click next and you will get email with Invoice link which will have Wire transfer instructions. When you sending payment via Wire transfer make sure you enter Payment reference number correctly to avoid delay in transaction (You can list it anywhere in the Wire transfer memo). Click here to learn more about purchase options.

No – We do not support ACH Transfer (Also known as Bank Transfer). However we do support Wire Transfer option (Using SWIFT) if you cannot use Credit card or Check method.

No – Annual Subscription only supports Credit/Debit Card option. If you must pay by check or wire transfer then you have to purchase Perpetual License rather than Subscription.

Yes – We have 30 days money back guarantee but you have to request refund in 30 days from your purchase date. Refund will go back to original card.

Click here to get W9 link

 FastSpring’s VAT number for EU  is EU826012240. The number begins with “EU” because FastSpring is located in the United States, not in a European Union member state. Click here to learn more

Click here to lookup VAT ID / Tax ID for your country. Click here to learn more.

As long as you have valid support agreement you are entitled to get new features/bug fixes at no additional cost. You can upgrade to new version for the same SKU from original purchase. For example if you purchased Standard Edition then you can upgrade to new version and get new features only for Standard Edition (not for Pro Edition)

If you upgrade within 30 days from the purchase date then you can just pay the difference and get a new license for the higher edition. However, if you upgrade after 30 days then your cost would be based on the following calculation. To get discount you must request quote from us. Always mention your previous order number in the request. Edition Upgrades are only allowed in Perpetual License. We do not allow Upgrades in Annual Subscription so you always have cancel existing Subscription and Purchase new Subscription with different SKU.

Example : Upgrade from Standard Edition to Pro Edition
Consider the following scenario where you bought Standard Edition @ $1899 per license. After few months you decide to upgrade to Pro Edition. You can calculate your upgrade cost based on the following table depending on how many months you used.

No – everything should just work fine. However, we recommend to backup before the upgrade. As per best practice, you should always test your new version in DEV first and then deploy to PROD.

To Check the installed PowerPack version please refer to below link:
https://zappysys.zendesk.com/hc/en-us/articles/115004417614

To Check the Release Notes refer to below links:

• SSIS PowerPack Release Notes
• ODBC PowerPack Release Notes

If you renew your support on time then your software continues under existing support agreement and you will be able to enjoy following great benefits.

• Download latest version to get critical bug fixes / New features
• Contact Support via Email/Phone/Chat/Webx regarding product issues or technical questions
• Obtain priority builds

We highly encourage you to renew support agreement before expiration date.

You can skip renewal period and buy later when you really need it, however when you renew support, you have to pay for any missed support periods including the current period before we can reactivate your support agreement. For example you bought a product ($1000 – one perpetual license) on Jan 1, 2010. Next year you decided to skip Support renewal (e.g. $250). But after 2 years on Jan 10, 2012 you needed urgent support for some product related issue (Production Jobs failing and you are not sure). Since you did not pay for support for Year 2011 and 2012 you will not be eligible to get technical support. To get support in year 2012 you must pay for current period (i.e. 2012) and any missed period(s) (i.e. Year 2011). So in total you have to spend 2 x $250 = $500

If you choose not to renew support agreement then old version will continue to work but you will lose following important benefits

• Download latest version to get critical bug fixes / New features from Customer Download Area
• Contact Support via Email/Phone/Chat/Webx regarding product issues or technical questions
• Obtain priority builds

No – Annual Subscription Plan already includes support and upgrades

No – When you renew support agreement we update our system so you can obtain technical support and download latest software. You don’t need new license key in order to install latest version. Old license key registration works automatically without any activation as long as you are installing new version on the same machine where license key is active.

SSIS PowerPack is a collection of 50+ high performance, drag and drop connectors/tasks for SSIS (i.e. Microsoft SQL Server Integration Services). After you install SSIS PowerPack you will see many new Custom Tasks and Components in your Visual Studio SSIS Toolbox. ZappySys Tasks/Components will be sorted with ZS Prefix (for VS 2008 toolbox wont refresh automatically so manually add items) Switch to Data flow and Control flow to see all components.

Click here to download fully functional 30-days trial. No need to activate Trial license because it will be embedded in the installer.

For paid customer you can download FULL version from this link.

Check this page for Supported OS / SQL Version and System requirements.

Check this page for Supported OS / SQL Version and System requirements.

In most cases you do not have to restart server / workstation for products we offer. However in rare case SSIS PowerPack users might have to restart SSIS Service to flush out cached dlls in memory only if your jobs failing to load SSIS PowerPack components.

Here is the direct link to latest build: Make sure you uninstall the previous version before installing this one (Go to control panel -> Add Remove programs -> Uninstall SSIS PowerPack)

https://zappysys.com/links/?id=10017

You can use the same installer you used
for desktop. After installation, you will get your 30-days trial on that new machine (assuming its first time install on that machine)

You can check our online help file, blog or ask question to support if none of that helps.

Many times users ask us this question. Do I need SSIS PowerPack or ODBC PowerPack. Sometimes they look like similar use case both products have their own set of features. Following few points may help you to understand it better.
When to use ODBC PowerPack

• When you have a need to read data without using any ETL approach (e.g. Read data directly from REST API and display in Reporting Tool)
• You are not using Microsoft SQL Server / SSIS for ETL or you don’t want to use SSIS (e.g. Your company is using Informatica rather than SSIS)
• You just need very specific driver available in ODBC PowerPack and don’t need to use any other features / connectors offered by SSIS PowerPack.
• You are a DBA / T-SQL Programmer for Microsoft SQL Server and like to access REST API or other data offered by our Drivers See this
• You are a programmer (e.g. C# , Java, Python) but don’t want to spend too much time to figure out data extraction / authentication / pagination / performance tuning logic for speedy development and easy to maintain.

When to use SSIS PowerPack

• You like to use SSIS as your primary ETL tool for data extraction / transformation
• You want to use additional tasks/ connectors / transforms available part of only SSIS PowerPack and not found in ODBC Drivers
• You like to use more visual interface rather than SQL Queries

Yes, if you upgrade/modify Visual studio or SQL Server on the machine, you need uninstall the SSIS PowerPack using Control Panel (Go to control panel -> Add Remove programs -> Uninstall SSIS PowerPack) and need to re-install the SSIS PowerPack with typical Default setting.
We recommend to use the latest SSIS PowerPack. Please refer to this link to Download the Latest Version.

By default when you create new SSIS Package it uses EncryptSensitiveUsingUserKey PackageProtectionLevel all secret fields (e.g. Password, Tokens) are encrypted using your User Key.
So when you try to run the same package under a different user account (e.g. Run via SQL Agent) then it will fail. The solution is simple. Just pass Sensitive information via Job Parameters Page or configure SSIS Catalog to use Environment feature. Most common Properties you need to set via parameters are Password, SecretKey, RefreshToken, PropxyPassword. For more information on Deployment and Parameterization check following links

Using SSIS Parameters to make things dynamic at runtime
SSIS 2012 Project Deployment
Deploying Packages to SSIS Catalog

If you want to know how secure is our product, Check this link

 Check this link