Enumerate Local packages.

[Bill Crawley]

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.

[Shuja Ali]

A simple stored procedure present in msdb gives you the DTS packages present on the server.
use msdb

EXEC sp_enum_dtspackages