SSIS on cluster

#1

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

#2

Link to my blog post on this very subject:
http://weblogs.sqlteam.com/geoffh/ar...-Question.aspx

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

"Nancy Lytle" <word_diva (AT) hotmail (DOT) com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSIS on cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

SSIS on cluster - 12-19-2007 , 11:17 AM

Re: SSIS on cluster - 12-19-2007 , 03:28 PM