SQL Server Performance

SSIS and Cluster

Discussion in 'SQL Server 2005 Clustering' started by Stubbydba, Mar 26, 2007.

  1. Stubbydba New Member

    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

  2. MohammedU New Member

Share This Page