In SQL2005, SSIS is not cluster aware.There is a way to make SSIS a cluster resource. See articlehttp://msdn2.microsoft.com/en-us/library/ms345193(SQL.90).aspxHowever, this solutions looks more like a workaround (that is supported by MS)The solutions provided have some drawbacks, as noted in the article.SSIS still stays "non cluster aware" out-of-the-box in SQL2005.Because of the release of the article above, it seems to me, that MS received feedback about the need of clustering SSIS from it's customers.
Category