EXEC master.dbo.xp_servicecontrol N'QUERYSTATE',N'MsDtsServer'

EXEC master.dbo.xp_servicecontrol N'QUERYSTATE',N'MsDtsServer100'

SET @REGKEY = 'System\CurrentControlSet\Services\MsDtsServer'

SET @REGKEY = 'System\CurrentControlSet\Services\MsDtsServer100'

------------------------------------
create table #instances
(c1 varchar (100),
c2 varchar (100))

insert into #instances 
EXEC master..xp_regenumvalues 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'


select c1 from #instances

drop table #instances.
------------------------------------