Home Forums SQL Server 2005 Administering DTS packages failed in SQL 2005 Failover Cluster passive node RE: DTS packages failed in SQL 2005 Failover Cluster passive node

  • Did you configure SSIS manually in the cluster group? The SSIS install is not cluster-aware, so you have to manually install it on the passive node and add it into the cluster group or the service will not be running on failover. Check the MS website for detailed instructions on setting this up - they offer a couple of options.