SSIS is not cluster-aware so installing to a SQL 2005 cluster is problematic. I'm running an Active/Active, two instance, two physical server Windows 2003 cluster so I installed SSIS on both nodes and configured to reference MSDB on both virtual server\instances. I did not create anything within cluster groups for SSIS.
Reference: http://msdn.microsoft.com/en-us/library/ms137789(SQL.90).aspx
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment