Can SSIS work in a Cluster

We have just installed a new SQL 2005 Clustered server and loaded integration services. However it appears that integrations services may not work properly in a clustered environment.

So can integration services be setup on a clustered SQL 2005 server



Answer this question

Can SSIS work in a Cluster

  • iceberg777

    How about if this is a multi instance cluster In the config fil there is only room for 1 server/instance of SQL. <ServerName>K-CLUSTER2-SQL1</ServerName>. Can other instances use this SSIS service Or is there additional configuration

    Thx


  • BBushmaker

    Funny, someone asked the same question earlier today. Is it clustering day :)

    Go here anyway: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=366352&SiteID=1

    -Jamie



  • Can SSIS work in a Cluster