OH.. CH4SQL1\INSTANCE01, CH4SQL2\INSTANCE02, CH4SQL3\INSTANCE03

all these 3 sql's are in same server/node with redundant 3 nodes for High availability?

Okay good. But still one niggling doubt. Why did you put 3 SQL instances in your xml instead of VirtualName?

okay. giving TWONODECLUSTER in <.> would enable me to manage ssis packages regardless of which node is active. Is that correct?

Cluster name: WINCLUSTER (which i use to connect in cluster admin)

Virtual Name: TWONODECLUSTER (which i give in SSMS to connect to sql.. doesnt matter which node is up)

This TWONODECLUSTER has...

Virtual name: virtual name and IP address that stays the same no matter what node in a cluster is active.

So my virtual name would be TWONODECLUSTER and i would...

OMG. I need to put the cluster name in <.> in both node xml files..thats it?

But, dougbert link had this,

http://dougbert.com/blog/post/ssis-and-clustering-what-you-should-do-instead.aspx

" let’s take this concept to a cluster. For...

Okay. Now, what i understand is, in 2 node cluster, i need to include both node names in the xml file of both nodes....so after failover, ssis can be managed...

So, it connects to the node whichver is up at the time. If that holds true, then after failover, <.> looks for Node2, which is up now and hence it...

My xml file has the default setup like

<Name>MSDB</Name>

<ServerName>.</ServerName>

....

this means that now it connects to default (active) server and on failover the passive becomes active...

guys,

Doubts keep creeping up at each step:-(

My cluster is default, not named. since, i connect to it using system name and not as systemname\instancename. so my assumption is that...

These were SQL 2000 DTS packages deployed to SQL 2008 R2. Converting them into SSIS is happening in parallel. But till we get complete SSIS package, we have to run...

Anthony,

You are amazing. Thanks much for the answers.

Anthony,

SSIS packages wouldbe run from agent jobs. Now i dont need to run or monitor ssis packges from management studio. I wont be installating SSIS on each nodes.

in case...

A strange doubt popped up now. Installing SSIS on each node is needed for importing packages to msdb (in addition to managing packages in msdb while failover).?

If i dont...

Anthony, really appreciate your answers. you made it to easy to understand.

Why the grumpy look? 🙂

Mr/Ms "want a cool Sig"

Thanks to you too. Your post gave me a starting...