List DTS pkgs

#1

All,

SQL Server 2000 sp3

I have a need to get a list of all DTS pkgs running on several servers. I
know EM lists them, but I need it for an email and did not want to have to
re-key entire list.

Thanks,
--
Keena Ferguson
Sr. DBA
Comdata Inc

#2

KeenaF wrote:

Quote:

All,

SQL Server 2000 sp3

I have a need to get a list of all DTS pkgs running on several servers. I
know EM lists them, but I need it for an email and did not want to have to
re-key entire list.

Thanks,

For local server packages -

select * from msdb.dbo.sysdtspackages

--
Darren
http://www.sqldts.com
http://www.sqlis.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

List DTS pkgs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

List DTS pkgs - 11-11-2005 , 11:28 AM

Re: List DTS pkgs - 11-11-2005 , 01:42 PM