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?
My recommendation would be to have a separate SSIS instance for each SQL Server instance, and add it to the resource group for that SQL Server instance.
ASKER CERTIFIED SOLUTION
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, I was confusing SSIS with something else. Aren't SSIS tasks scheduled to run in the SQL Server Agent, which is based per-instance?