Dear sir Our Enviroment Sql Server Clustering & Windows Clustering . One node load the Sql Server management package load properly and other node sql server packges failed to load error occured how to solve the issue
Hi, Maintenace plans uses SSIS and SSIS is not cluster aware. You can setup SQL Server Agent to run the package instead; see http://support.microsoft.com/kb/942176 "Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service". Step by step to set it up can be found here: http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx. HTH! /Elisabeth
