Enumerate Local packages.

Hi All,

In SQLServer 2000 there are local packages. I need to write a script that will enumerate the local Packages store and return me the name of each DTS. I thought I could use LoadFromSQLServer but that only appears useful if you know the package name.

Any ideas?

Thanks.
[302 byte] By [Bill Crawley] at [2007-11-20 7:22:08]
# 1 Re: Enumerate Local packages.
A simple stored procedure present in msdb gives you the DTS packages present on the server.
use msdb

EXEC sp_enum_dtspackages
Shuja Ali at 2007-11-9 13:45:12 >