Note: The use of SSIS is not recommended in projects with ODX Server.
The Remote Execution of SSIS Packages feature improves performance when TimeXtender is installed using a separate application server and database server configuration.
When using this configuration, the default ADO.net transfer will move data from a source and through the application server to land in the target SQL database. Even on a high-speed LAN, this is considerably slower than having TimeXtender and SQL Server on the same machine.
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.
Compatibility and Prerequisites
Remote Execution of SSIS Packages is supported by Discovery Hub 17.12.13 and forward.
SSIS must be installed on both the local and remote servers. The SSIS version on the local server and the SSIS version on the remote server must be the same version for the Remote Execution service to work. Click the following link to learn more about using TimeXtender with SQL Server Integration Services.
Click the following link to learn how to Configure Remote Execution of SSIS Packages.
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 2019
SQL Server 2017
SQL Server 2016
SQL Server 2014
SQL Server 2012
SQL Server 2008 / 2008R2
SQL Server 2005
What's new in version 2 of the remote execution of SSIS packages?
We updated a dependent assembly which is used to convert string values to datetime values. The assembly updated is only used by the SAP Adapter.
our customer want to modify his installation, moving his databases to a dedicated sql server and keeping Discovery Hub on an application server. We'll use 'remote execution of SSIS' tool. On the dedicated SQL server, our customer is using 'AlwaysOn availability group' technology.
In this group there are 2 sql servers, and on our DH project we'll connect on a third server.
Is remote Execution of SSIS working with this type of installation ? On which server do we have to install the tool ?