System Requirements and Installation

Tip: SSIS PowerPack is a collection of powerful SSIS components for integrating virtually any data source — REST, JSON, XML, CSV, API, OData, Amazon S3, Azure, Google, and more.

Design Prerequisites

To design SSIS packages, install Visual Studio with the SQL Server Integration Services Projects (SSIS Designer) extension.

Visual Studio 2022 / Visual Studio 2026 – Install SQL Server Integration Services Projects 2022+ (Microsoft).
Target server versions supported: SQL Server 2016–2025 (including SSIS 2025).
Download extension
Visual Studio 2019 – Install SQL Server Integration Services Projects (VS2019 extension).
Target server versions supported: SQL Server 2012–2022.
Download extension
Legacy Note (older tooling): Older SSDT / SSDT-BI installers exist mainly for backward compatibility with older Visual Studio setups.
See Microsoft SSIS documentation for details.

Supported SSIS Versions

SSIS 2025, 2022, 2019, 2017, 2016, 2014, 2012

Supported SQL Server Version for SSIS Package Deployment

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012
Windows operating system only

Supported SQL Server Editions

Supported Editions (Windows only)
- SQL Server Enterprise Edition
- SQL Server Standard Edition
- SQL Server Developer Edition
- SQL Server Evaluation Edition
Not Supported
- SQL Server Express Edition (SSIS not supported)
- SQL Server Web Edition (SSIS not supported)
- SQL Server on Linux or Mac (PowerPack is Windows-only)

Azure Data Factory – SSIS Integration Runtime

Use Visual Studio 2026, 2022, 2019, or 2017 with the SSIS Projects extension to design and deploy SSIS packages to Azure Data Factory SSIS Integration Runtime (ADF SSIS-IR).
Important: Set TargetServerVersion = SQL Server 2017 in your SSIS project for compatibility with ADF SSIS-IR.
See this guide to change the target version: How to change SSIS Package TargetServerVersion in Visual Studio .

Operating System Requirements

Desktop OS: Windows 11, Windows 10, Windows 8, Windows 7
Server OS: Windows Server 2025, Windows Server 2022, Windows Server 2019, Windows Server 2016, Windows Server 2012
64-bit OS is required
If your OS is not listed here, it may still work. Please contact us at support@zappysys.com for assistance.

Installation Steps

Download the SSIS PowerPack Installer:
https://zappysys.com/downloads/ssis-powerpack
Run the installer and follow the on-screen instructions.
Restart Visual Studio after installation (if open).
Launch Visual Studio and create a new SSIS project to start using SSIS PowerPack.

Important: If you purchased the software, download the installation file from the Customer Download Area. You cannot activate a purchased license key with the public trial build.

Uninstallation

Go to Add or Remove Programs in Windows and search for ZappySys SSIS PowerPack.
Select it and click Uninstall.
If you installed separate builds for different SQL/VS versions, uninstall each version as needed.

Troubleshooting Tips

If Visual Studio crashes at startup, see ZappySys Troubleshooting Guide .
If new components do not appear, close all Visual Studio windows and restart Visual Studio using Run as Administrator.

For Beginners: Refer to this article – Getting started guide (How to design, debug, deploy, and schedule SSIS packages using SQL Agent and SSIS Catalog).

For additional support, visit our Support Portal.