How to install SSIS PowerPack in Visual Studio 2026

SSIS PowerPack Getting Started
, ,
1

Introduction

SQL Server Integration Services (SSIS) is a powerful tool for data integration and workflow automation. Setting up SSIS in Visual Studio 2026 is straightforward when you install the appropriate extensions and tools. This guide walks you through the step-by-step process to enable SSIS functionality in Visual Studio 2026 so you can create, manage, and deploy ETL packages and use ZappySys SSIS PowerPack components.

Prerequisites

  • Visual Studio 2026 installed on your machine.
  • Administrator privileges for installing extensions.

Steps

Step 1: Open Visual Studio

  1. Launch Visual Studio 2026.
  2. Click on Continue without code
  3. Go to the top menu and select Extensions > Manage Extensions.
    Manage Extensions
    Manage Extensions572×150 12.8 KB
  4. Use the search bar to find SQL Server Integration Services Projects (2022+), or download it here.
    Search for SQL Server Integration Services Projects
    Search for SQL Server Integration Services Projects1216×381 42.7 KB

Step 2: Install the SSIS extension

  1. Check the version for Visual Studio 2026.

  2. Follow the prompts in the Visual Studio Installer to complete the setup.

    SQL Server Integration Services Projects installer
    SQL Server Integration Services Projects installer697×602 19.8 KB

  3. After installation, restart Visual Studio.

Step 3: Verify installation

  1. Open Visual Studio and go to Create a new project.

  2. Search for Integration Services in the project template search bar.

  3. Select Integration Services Project and click Next.

    New project
    New project892×577 38.1 KB

  4. Configure the project name and location, then click Create. You should now see the SSIS Designer interface, including the Control Flow, Data Flow, and Parameters tabs.

Troubleshooting

SSIS templates not visible

  • Refresh extensions: If the SSIS templates are not visible, go to Extensions > Manage Extensions and verify that the SQL Server Integration Services Projects extension is installed and enabled.
  • Reset templates: Click Tools > Import and Export Settings, and reset all settings to their default values.

Missing dependencies

  • Ensure you have installed the required SQL Server tools (for example, SQL Server Data Tools) during the Visual Studio installation process.

Step 1: Install ZappySys SSIS PowerPack

  1. Download the installer for trial or paid users.
  2. Run the installer as an administrator and follow the on-screen instructions.
  3. Restart Visual Studio and verify the components are available in the SSIS Toolbox.

Step 2: Change SQL version

  1. If you do not see our components inside the toolbox, then right-click on your project name and select Properties.
  2. Go to Configuration Properties and change the TargetServerVersion to SQL Server 2022.
    Change SQL server version
    Change SQL server version1189×857 58.9 KB

Step 3: Solve the error message while opening an existing project

  1. When you open an existing package, you could get this error message from one of your packages.

    Error message opening an existing project
    Error message opening an existing project364×154 1.94 KB

  2. Close the error message and the package tab.

  3. Then open your package again, and it will work normally.

If you are using Visual Studio 2022, this article can help; the steps are similar in Visual Studio 2026.

Contact us

If you encounter any issues or have specific questions, reach out to our support team via live chat or submit a support ticket using our email: support@zappysys.com.

References