Follow

Remote Execution of SSIS Packages

Introduction

The Remote Execution of SSIS Packages feature improves performance when TX DWA is installed separately from the SQL Server that houses the data warehouse.

When this is the case, all traffic from source systems to the staging databases and data warehouses has to pass through the TX DWA machine where TX DWA opens and executes the SSIS packages it has generated. Even on a high-speed LAN, this is considerably slower than having TX DWA and the data warehouse on the same server.

As the name suggests Remote Execution of SSIS Packages lets you execute SSIS packages on a remote server, typically the server that houses the actual data warehouse, saving the data an extra trip through the network cables.

Compability

Remote Execution of SSIS Packages is supported by the following TimeXtender DWA platforms: TX DWA, TX2014 SP2, TX2014 SP1.

Installation Instructions

Please see the user guide for the feature for installation instructions.

Download

Below, you can download the Remote SSIS Execution installation package. Select the version that matches your Microsoft SQL Server version and bit version.

SQL Server 2005

SQL Server 2008 / 2008R2

SQL Server 2012

SQL Server 2014

SQL Server 2016

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.