I have asked one question about the ssis service on sqlserver 2005 cluster. the content is as belowing: i installed ssis service on each node,and modify the ssis configuration file on each node also. here is two format,but i don't know which one is right.\ first: <?xml version="1.0" encoding="utf-8"?> <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB</Name> <ServerName>NEOCLUSTERFIS\NEOFISDB</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration> NEOCLUSTERFIS is the name of windows cluster,NEOFISDB is the network name of SQL Server cluster. second: <?xml version="1.0" encoding="utf-8"?> <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>NEOFISNODE1 MSDB</Name> <ServerName>NEOFISNODE1\NEOFISDB</ServerName> </Folder> <Folder xsi:type="SqlServerFolder"> <Name>NEOFISNODE2 MSDB</Name> <ServerName>NEOFISNODE2\NEOFISDB</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration> NEOFISNODE1 and NEOFISNODE2 are the names of two nodes NEOFISDB is the network name of SQL Server cluster. And i can find SSIS service on each node. Here i have some questions, I can save package to file system(on cluster driver) and can directely execute it.but i can't run it in sql server job.it comes out some error? How can I resolve it? I can't create Maintenance plan on each node,the error message is: TITLE: Microsoft SQL Server Management Studio ------------------------------ Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.MaintenancePlanTasksUI) ------------------------------ BUTTONS: OK ------------------------------ But i can create maintenance plan when connecting to the cluster database remotely. what is the right way to fix the problem,then i can create maintenance plan locally.If you haven't all the things you want,be grateful for the things you don't have that you didn't want.

Hi Wison First of all i'm presuming that the configuration examples are from Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrv.ini.xml? If so then this is the example that I have for a three node, two Two Server Cluster environment: - <?xml version="1.0" encoding="utf-8"?> <DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown> <TopLevelFolders> <Folder xsi:type="SqlServerFolder"> <Name>MSDB</Name> <ServerName>.</ServerName> </Folder> <Folder xsi:type="FileSystemFolder"> <Name>File System</Name> <StorePath>..\Packages</StorePath> </Folder> </TopLevelFolders> </DtsServiceConfiguration> Note that All files are identical on all three nodes; even though I have two Clustered Environments. As SSIS is not cluster aware then you need to: - Store any SSIS Packages within MSDB; storing them in the file system will not work. As you are creating Maintenance Plans for a clustered instance then you need to connect to the clustered instance; when SQL Server saves the Maintenance Plans it will save them in msdb. You will also need to uninstall SSIS and then reinstall on each node as Default instances.Please click "Mark As Answer" if my post helped. Tony C.

is it Active/passive or Active/Active cluster?Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com