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