I am trying to use a stored procedure to look for all the DTS packages
stored on the system of sql server7 and sql server 2000,

Is there a system table where the names are stored?

Thanks,

Tom

sysdtspackages is where the packages are located (providing you saved them
to SQL Server)

You will be interested in this proc

sp_enum_dtspackages

Also have a look at this article

Enumerating DTS Packages using VB.Net
(http://www.sqldts.com/default.aspx?250)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Thomas Scheiderich" <tfs (AT) deltanet (DOT) com> wrote