SSIS in a Clustered Environment

• smirabella

  Mr or Mrs. 500

  Points: 519

  More actions

  October 2, 2007 at 9:08 am

  #118369

  Hi,

  I have SQL 2005 in a clustered environment (two nodes). SSIS is NOT configured as a cluster resource since Microsoft recommends that it not be. Instead, SSIS has been installed on each node in the cluster and I've modified the SSIS configuration file on each node ot reference the proper SQL Server Instance.

  When Node A is "online" I can use SQL Management Studio to view/manage the SSIS packages in the "msdb" folder. When there is a failover to Node B, the SSIS service is running and I can run jobs that run SSIS packages. However I cannot see the contents of the "msdb" folder in SSIS nor can I import packages to it.

  I'm already aware of the following documents from msdn which I've read and which served as the basise for configuring the SSIS configuration file:

  http://msdn2.microsoft.com/en-us/library/ms345193.aspx

  http://msdn2.microsoft.com/en-us/library/ms345193.aspx

  Is there any particular configuration or other change I need to make? I'll appreciate any information any one can offer.

  Thanks!