Installing Integration Services on existing Active\Active Cluster

• timscronin

  SSCertifiable

  Points: 6851

  More actions

  August 2, 2011 at 3:19 pm

  #245519

  I want to install Inegration Services on an existing sql 2005 active/active cluster. SSIS is currently installed as a non clustered resource on one of the nodes. Their are jobs which run file based SSIS packages. Can I install SSIS on the second node and have the service running, and if this is true, if the active/active fails over to this node, will the jobs run the SSIS file packages?

• captain.norton

  Grasshopper

  Points: 13

  More actions

  August 22, 2013 at 1:42 am

  #1643777

  AFAIK jobs need being restarted manually

  http://msdn.microsoft.com/en-us/library/ms345193.aspx