SQL Server Performance Forum – Threads Archive
SSIS and Cluster
I have A few questions/problems realated to SSIS. Here is my system info SQL Server 2005 SP1Windows 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
]]>