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.
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.
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.
Its upto you whether you want such failover mechanism or not, if not needed then simply go by your process.
