Integration Services on a Multi-Instance SQL Server Cluster (Best Practice)

Hi
I have a 2-node active-passive SQL cluster (with SSIS manually
clustered in the SQL resource group). I want to convert to active-
active by installing a named instance on the second node. Am I correct
in saying that the new virtual server cannot have its own SSIS
instance but must instead utilise the SSIS instance (& the MSDB
database) of the first (original) virtual server (because there can
only be one instance of SSIS on a node) ?
Having said this, should I move the SSIS resources into (preferably) a
dedicated SSIS resource group or (alternatively) the cluster/quorum
group, moving the xml config file and the Packages folder to the
associated physical disk for that group ?
tia
brynjon
SSIS is typically set up as a local instance for each cluster node. Note
that each node must be installed independently. You can cluster the
resulting SSIS installations and refer to them a a cluster resource.
Here is Kirk's blog entry on how to do that:
http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"brynjon" <bryn.jones@.cheshire.gov.uk> wrote in message
news:1178014798.452341.88160@.p77g2000hsh.googlegro ups.com...
> Hi
> I have a 2-node active-passive SQL cluster (with SSIS manually
> clustered in the SQL resource group). I want to convert to active-
> active by installing a named instance on the second node. Am I correct
> in saying that the new virtual server cannot have its own SSIS
> instance but must instead utilise the SSIS instance (& the MSDB
> database) of the first (original) virtual server (because there can
> only be one instance of SSIS on a node) ?
> Having said this, should I move the SSIS resources into (preferably) a
> dedicated SSIS resource group or (alternatively) the cluster/quorum
> group, moving the xml config file and the Packages folder to the
> associated physical disk for that group ?
> tia
> brynjon
>