If all the servers are linked from one, you can execute thisCreate Table #t (server sysname, dts sysname);Declare @server sysnameDeclare c Cursorread_onlyfor	select data_source from sys.servers where is_linked = 1 or data_source = @@servernameopen cfetch next from c into @serverwhile @@fetch_status = 0begin	insert #t	EXEC ('SELECT ''' + @server + ''', name FROM [' + @server + '].msdb.dbo.sysdtspackages')	fetch next from c into @serverendclose cdeallocate cselect distinct server from #tdrop table #t