Environment: Win03EEsp2+hotfixes, Sql2005EEsp2+CumUpdate3
I need to fully understand before I setup the cluster.
1) I will need to install SSIS (Node1) to use the maint wizard and to edit the maint jobs. When the Cluster is on Node2 the jobs will still execute?
1a) When the Cluster is on Node 2, will I be able to edit the maint jobs?
2) Cluster is on Node1, developer makes a SSIS package and it is saved to SQL msdb (or does it matter), then the SSIS is scheduled, when it rolls to Node2 will it run?