SSIS on cluster

External Since: Dec 09, 2005 Posts: 3

We are going to be setting up a new SS2k5 2 node/2active instance cluster
and I have a question about Integration Services. We do use some SSIS
packages run by jobs in our environment (and I think we will trying to use
more and more in the future) and I am wondering, do we need to worry about
integrating SSIS into the cluster or just set it up without regard to the
cluster? I have read that there can be some issues involved when you try and
cluster SSIS.
Any advice/suggestions welcome.
Thanks in advance,
Nancy

External Since: Feb 23, 2005 Posts: 443

Link to my blog post on this very subject:
http://weblogs.sqlteam.com/geoffh/archive/2007/10/04/To-Cluster-or-Not...-Cluste

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Nancy Lytle" wrote in message

> We are going to be setting up a new SS2k5 2 node/2active instance cluster
> and I have a question about Integration Services. We do use some SSIS
> packages run by jobs in our environment (and I think we will trying to use
> more and more in the future) and I am wondering, do we need to worry about
> integrating SSIS into the cluster or just set it up without regard to the
> cluster? I have read that there can be some issues involved when you try
> and cluster SSIS.
> Any advice/suggestions welcome.
> Thanks in advance,
> Nancy
>