How to install SSIS PowerPack in clustered environment

A cluster refers to a group of interconnected computers or servers that work together to perform computing tasks as a single cohesive unit. The goal of clustering is to enhance the availability, reliability, and scalability of a system by distributing the workload across multiple machines.

What is the Active-Active configuration?

Active-Active configuration is a high-availability setup in which multiple nodes or servers are actively participating in serving requests or processing tasks simultaneously. In this configuration, all nodes are actively engaged in handling a portion of the workload concurrently, distributing the traffic or workload across them. This is in contrast to an Active-Passive configuration where only one node is actively serving traffic while others remain on standby as backups.

What is the Active-Pasive configuration?

In an Active-Passive configuration, multiple nodes or servers are set up in a way that only one node, the “active” node, actively handles incoming requests or processes tasks at any given time. The other nodes, known as “passive” nodes, remain on standby and do not actively participate in serving the workload. The passive nodes are essentially in a hot standby state, ready to take over if the active node fails or if a failover event is triggered.

How to install SSIS PowerPack in an Active-active configuration

Installing the SSIS PowerPack in an Active-Active configuration involves configuring SQL Server Integration Services to support high availability, and then installing the SSIS PowerPack on each node of the cluster.

First download our tool, you can use our trial or paid version. Run the SSIS PowerPack installer on the first node of the cluster and follow the installation wizard

During installation, ensure that you configure the installer to recognize the clustered environment. Provide the necessary details about the SQL Server instance and cluster configuration and if you have a valid license, activate the license key

Complete the installation on the first node. Repeat the installation process on each additional node of the cluster. Ensure that you provide the same configuration details for each installation. (Each license is per node)

The last step is to test your SSIS packages to ensure that they run successfully in the clustered environment. Simulate failovers or monitor failovers to ensure that SSIS PowerPack continues to function seamlessly during failover events.

How to install SSIS PowerPack in an Active-passive configuration

Installing SSIS PowerPack in an Active-Passive configuration involves configuring SQL Server Integration Services (SSIS) to support high availability and then installing the SSIS PowerPack on both the active and passive nodes. Here are the general steps:

First download our tool, you can use our trial or paid version.

Set up a SQL Server Failover Cluster if not already configured. This involves configuring shared storage, IP addresses, and installing SQL Server in a failover cluster instance. Install SQL Server Data Tools (SSDT) and SQL Server Integration Services (SSIS) on the cluster. Configure SSIS to work in the clustered environment.

Run the SSIS PowerPack installer on the active node of the cluster. Follow the installation wizard, accept the license agreement, and specify installation options

During installation, ensure that you configure the installer to recognize the clustered environment. Provide the necessary details about the SQL Server instance and cluster configuration. Complete the installation on the active node

Copy the SSIS PowerPack installer to the passive node. Run the installer on the passive node using the same configuration details used on the active node.

Test your SSIS packages to ensure they run successfully on both nodes. Simulate failovers or monitor failovers to ensure that SSIS PowerPack continues to function seamlessly during failover events.