Avatar of jwa082276
jwa082276 asked on

WINDOWS 2003 CLUSTER; SQL 2005; SSIS; FILE SHARE

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

Avatar of undefined
Last Comment
Onlyodin

8/22/2022 - Mon
Onlyodin

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
jwa082276

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Onlyodin

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?
Your help has saved me hundreds of hours of internet surfing.
fblack61