SQL Server Performance

SSIS in Clustering

Discussion in 'SQL Server 2005 Clustering' started by Fais, Feb 4, 2008.

  1. Fais New Member

    Hi All,
    I am going to install SQL Server 2005 in Clustering Env.( Active-Passive). As I know, Integration Services in not cluster aware, how should I deal with SSIS service.
    Currently, we have some SSIS packages which run nightly. For most of them, package source is configured as “File System” and for other package source is configured as “SQL Server”.
    (1) So, I wanted to know, should I install SSIS service separately on passive node as we install client tools separately on Passive node.
    (2) Should I make SSIS service as Cluster aware by following these steps. http://sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx
    (3) What will be effects if we configure (or) not configure SSIS to run as Cluster aware service.
    Please give some ideas.
    Thanks.
  2. satya Moderator

    As you have already referred the link, look also for http://msdn2.microsoft.com/en-us/library/ms345193.aspx & http://www.jumpstarttv.com/Media.aspx?vid=36 that will give you more information.
    If you do not enable SSIS as cluster based, then the problem will be with failover of nodes and running those ETL jobs. Say you are supporting a large production environment and need to minimize downtime as much as possible, that will raise a need to create a separate stand-alone SSIS server.
  3. Fais New Member

    I havent seen the jumpstarttv webcast yet, but read msdn paper.
    So, if we decided not to cluster SSIS service, then by having Integration service on both the nodes is enough (or) have to do any other configuration setting change.
    Please let me know satya.
    Thanks.
  4. satya Moderator

    Its upto you whether you want such failover mechanism or not, if not needed then simply go by your process.

Share This Page