I have a windows 2003 cluster (64 bit) (running active/active) with 2 named instances of sql 2005; I decided not to cluster ssis service and instead to just let the service run on each node. I copied the MsDtsSrvr.ini.xml from the c:\ to a drive on the san. I edited the xml file to have the "server name" be the windows virtual cluster name and pointed the "store path" to the drive owned by the cluster resources and then updated the registry on both nodes to look for this file. I know that only one owner can "own" that drive that holds the xml file at any one time. Since I am running active/active, and one sql instance will run on one node and the other sql instance will run on the second node, can both of the nodes access the drive and run the packages on each node? Do I need to setup a cluster share?
Windows OSMicrosoft SQL Server 2005Microsoft SQL Server