all groups > sql server dts > april 2004 >
You're in the

sql server dts

group:

DTS and Cluster


DTS and Cluster Tunji
4/14/2004 1:29:36 PM
sql server dts:
I assume its not required to have this package(s) run on both servers in an
ACTIVE - ACTIVE environment.

All opinions are welcome.

Thanks

--
Tunji




Re: DTS and Cluster Tunji
4/14/2004 2:32:20 PM
Thanks Darren!

--
Tunji
mcdba, ocp
www.geniant.com
[quoted text, click to view]

Re: DTS and Cluster Darren Green
4/14/2004 8:25:05 PM
In message <ePdPD6kIEHA.2924@TK2MSFTNGP09.phx.gbl>, Tunji
<Tunj@hotmail.com> writes
[quoted text, click to view]

It is not required, but packages should be capable of being run on both
nodes, for when the cluster fails over. So any files a package needs
should be on cluster resource disks so that they move between nodes with
the package and sql server, assuming packages are stored in and executed
from a SQL Server instance.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org
AddThis Social Bookmark Button