SSIS on cluster....

Last Post 22 May 2009 11:25 AM by sqladmin. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
mcdye
New Member
New Member

--
05 Dec 2007 10:41 AM
In a cluster environment with 1 nodeA having SSIS. Then some wizard maint jobs are setup and scheduled, then roll everthing to nodeB will there be any issues about the scheduled jobs running on nodeB?
mcdye
New Member
New Member

--
12 Feb 2008 06:25 AM
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?
sqladmin
New Member
New Member

--
22 May 2009 11:25 AM
just reading over this post... and need some clarification.

are you saying mod the MsDtsSrvr.ini.xml on each member node in the cluster, and if so... what mods exactly rm?

instance names to virtual cluster name?


Acceptable Use Policy
---