I have A few questions/problems realated to SSIS. Here is my system info SQL Server 2005 SP1 Windows Server 2003 R2 SP2 Active/Active Cluster MSDTC is clustered Node 1 = Dev Node 2 = QA So here is the problem/Questions On one node I have VS installed I don't have it on the other node. On both nodes i am unable to launch the Business Intellegence DS. There are no shortcuts to it althought I beleive the short cut just points ot the VS executable. So why can't I see it? Do I need to cluster the SSIS service? Another thing is although SSIS is installed I can't see it in the SAC tool. Should I be able to? I guess I will just start with that for now Thanks MK
SSIS is not cluster aware, I think you need to install on both nodes individually... SQL Server 2005 Books Online How to: Configure Integration Services on a Cluster http://msdn2.microsoft.com/en-us/library/223c3a59-84c3-4f60-be98-a8daf69e9473.aspx MohammedU. Moderator SQL-Server-Performance.com
