Posted by Ram on 10/19/06 11:56

Hi,
I have a existing DTS which is failing because of problems connecting
to WMI on a server.I have a table which is supplying two database
names.Problem occurs when one of those servers called is out of
production for any reason.I need a solution so that if the called
server fails to respond then the other server can cater to the
requirement.

As per my analysis, finding out the server not in load balancing mode
and ignoring that server for enabling and disabling of resources -would
server the purpose.
But i donot know how to find out the load balancing mode of the servers
and implement it in DTS.

Please can anyone guide me in this respect and tell me how to make the
DTS intelligent enough to handle the situation.

Regards,
Ram.

• Next in forum: Re: unable to run mysql server 5 on windows
• Prev in forum: Learning about Indexes
• Thread view: Need help in writing a VB Script in DTS to establish relation with WMI resources

[Reply to this message]