This project has moved and is read-only. For the latest updates, please go here.

SSIS service on different server then DB instance

Feb 11, 2014 at 7:00 AM
I have a SSIS service installed on different server then DB instance which is on SQL Cluster. Where should I install SSIS Multiple Hash - on SSIS service server or the Cluster or maybe on both?
Feb 11, 2014 at 7:30 AM
You should install SSIS Multiple Hash on the server where you will be executing the SSIS package.

In your case it sounds like the "different server".
I am assuming that you are running the packages via DTEXEC.exe.

If you are executing the packages from SQL Agent on a cluster, then you will need to install SSIS Multiple Hash on all nodes in the cluster.
Please note that the installer is not cluster aware, so you will have to run it on each node.
Marked as answer by agoszczynski on 2/10/2014 at 11:53 PM
Feb 11, 2014 at 7:53 AM
Thank you Keith, it is working as you suggested.

Best,
Adrian